|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
|
|
#1
March 18th 08, 06:04 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
Import Contacts from a CSV file
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 
|
|
#2
March 19th 08, 06:42 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
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
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| how to import CSV file to contacts | Gavin | Outlook - Using Contacts | 3 | October 16th 09 09:38 PM |
| can i import a mdi.file for microsoft contacts? | sunnytravels2 | Outlook - Using Contacts | 1 | October 16th 07 10:06 PM |
| How to import Outlook contacts without .pst file | [email protected] | Outlook - Using Contacts | 3 | November 18th 06 09:52 AM |
| Can't import a CSV file into Contacts | don | Outlook - Using Contacts | 1 | November 1st 06 09:24 PM |
| Unable to import contacts pst file | Rob | Outlook - Using Contacts | 6 | August 14th 06 09:27 PM |
Hybrid Mode
