Export Outlook Contacts to Access including distribution lists

I need to export the Contacts from Outlook 2003 and Outlook 2010 to an access file but I need to include the distribution lists.  The export wiz in Outlook that writes an Access file appears to only include single contact records - it doesn't include the distribution lists.  Has anyone seen any scripts out there (or free sofware) that take care of this?

TIA
dneill8IT ConsultantAsked:
Who is Participating?
 
Hendrik WieseInformation Security ManagerCommented:
Hi,

Have you tried exporting to CSV and then import using Access?

For instructions please see: http://www.ehow.com/how_5976818_import-csv-files-access-tables.html

Cheers!!!
0
 
hnasrCommented:
Never tried that!
A workqaround you find a better solution.
From the contacts table in access (you exported that to access table), add a column: listID
Open the table and add 1 for list 1, 2 for list 2 and so on.
Create another table for lists(listID, listName, desc, info,  ...)
1 list1, ....
2 list2, ....
....

Join the 2 tables on listID, and continue your work.
0
 
dneill8IT ConsultantAuthor Commented:
Fast.  Thank you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.