J
Jeff Steele
The documentation for importing an EXCEL spreadsheet into Outlook Contacts is
poor. It does not mention that the EXCEL spreadsheet must first have a named
range. That should be covered as should the proper way to define the named
range. I have spent the better part of 3 days trying to import a spreadsheet
with contacts information and the only way I was able to make it work was to
save my EXCEL spreadsheet as a CSV file and then use the Outlook import
wizard. I only found this answer by reading the Community posts. Once I
read ALL of the posts, I finally figured out that the original problem I was
experiencing (which was obviously encountered by several others) was that I
was not defining the named range in EXCEL properly. This is not an easy
procedure and the documentation should contain all of the necessary steps
with illustrated examples.
poor. It does not mention that the EXCEL spreadsheet must first have a named
range. That should be covered as should the proper way to define the named
range. I have spent the better part of 3 days trying to import a spreadsheet
with contacts information and the only way I was able to make it work was to
save my EXCEL spreadsheet as a CSV file and then use the Outlook import
wizard. I only found this answer by reading the Community posts. Once I
read ALL of the posts, I finally figured out that the original problem I was
experiencing (which was obviously encountered by several others) was that I
was not defining the named range in EXCEL properly. This is not an easy
procedure and the documentation should contain all of the necessary steps
with illustrated examples.