View Single Post
  #2  
Old March 19th 08, 06:42 PM posted to microsoft.public.outlook.program_vba
Eric Legault [MVP - Outlook]
external usenet poster
 
Posts: 830
Default Import Contacts from a CSV file

Have you tried the import tools from File - Import and Export...? The
wizard can import contacts from a .csv. However, if you wish to map any
columns in that .csv to a custom property, you would need to use code.

--
Eric Legault - Outlook MVP, MCDBA, MCTS (SharePoint programming, etc.)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/


"dgd2" wrote:

We have a database of contacts that is currently maintained in a FoxPro
Database. The contacts can be periodically exported to a csv file. We would
like to have these contacts available in Outlook in a folder under My
Contacts. I would like a macro a user could run to update the contacts in
the folder using info from the CSV file.
I'm guessing a routine that would empty the existing contacts from the
folder and then reimport from the csv file might be the easiest approch - but
since it's been years since I have done any VB programming I'm at a loss
really where to start.

Thanks,

David

Ads