I have a spreadsheet that has 3 columns: Name, Email address, Organization.
What is the best way to convert this to an Outlook 2010 Contact Group? Or is this not possible?
A good answer would explain how to format the column headers, which file type is best to use, and any tips on using the "Import from File" or alternate method from Outlook. I have access to MS Word, MS Access, MS Excel as well as a text editor to do this.
Solutions I have tried:
a. I have tried importing it as a .csv but only the names appeared in the new group, no e-mails.
b. I tried importing as .xls but it produced range definition errors.
c. I tried exporting my current contacts into a .csv spreadsheet, deleting everything but the headers, and then filling in the information using the Outlook generated headers. When imported, the result was spotty with some blank contacts and no e-mail addresses.