Import contacts

[Kenneth John Barclay]

I have an Access 2007 database and one of the tables includes names,
addresses and email addresses of clients. I have tried exporting the records
as a text file with headers. The separating character was set to tab.
I then tried opening the contacts window in Mail and selected import. I
selected the CSV option and the next dialog asked for the file name. This
was provided and the next dialog asked for the field to import (only 1
field) and I selected the header titled email address from the text file. I
received an error message and no contacts were created.
Any help would be appreciated.
Thanks in advance,
Ken

--

Kenneth John Barclay

This message is constructed
with 100% recycled bits.

 

[PA Bear [MS MVP]]

Import, export, or change the format for contacts - Windows Vista Help:
http://windowshelp.microsoft.com/Windows/en-US/help/65fbffa9-0ba5-45d8-a60f-ded4e86f01de1033.mspx

I would strongly suggest that you first export your current Contacts to a
CSV file and examine the formatting. Now edit the CSV file you want to
import to conform to the formatting of the CSV you exported.

 

[Kenneth John Barclay]

Thanks for your quick response. I realize the folly of my ways. CSV to me
meant 'Character Separated Variable' which was used many many years ago. It
would appear that Windows Mail can only interpret 'Comma Separated
Variable'. Access allows the saving of a text file with one of numerous
separator characters. I had chosen the 'tab' and it is not recognized by
Windows Mail as a separator.
Thanks again.
Ken

--

Kenneth John Barclay

This message is constructed
with 100% recycled bits.

 

[PA Bear [MS MVP]]

YW & thanks for your feedback.

CSV = Comma Separated Values