What's the best way to Import CSV data to Outlook Contacts weekly?
Posted on 2004-08-23
I have a client with a proprietary system for managing their business that also contains all their contact information. They would like to have this information in a public folder of Outlook contacts also.
The proprietary system has some features that will let me export the data to a CSV file - name, address, phone number, etc.
I would like to automate the process of importing this data to Outlook. I did a dry run with the Outlook import tool, and it's pretty close. But I think to truly automate it (and remove office workers from the equation) I will need to use some script or some such.
I programmed in the (distant...) past, and have read through posts suggesting that this can be done. In my head, I imagine a solution where I write a VBS script to read the CVS file and use the Outlook model to write it out. Is this the way to go? If so, can someone give me a sample script I could modify to match the fields I have?
My CSV today has stuff like this...
First Name Middle Name Last Name Suffix Company Name Phone Number Fax Number Mobile Phone Business Street Business Street 2 Business City Business State Business Postal Code Email Address
Thanks for ideas and help!