Steven Reid
asked on
How to export multiple contact folders in Outlook 2012 PST to csv file
Hi All,
We have been using multiple Outlook contacts folders as a very poor mans CRM system and now want to extract the data and import into a database.
We have the following layout
Contacts
- MFA1001
- MFA1002
- MFA1003
- SSSC1101
- SSSA1107
etc with each sub folder name being the course and date that someone has done.
each folder (including the contacts folder) has 1 to n contacts.
I would like to export all of the contacts into a CSV or Excel file including the folder name as part of the extracted record.
e.g. Title, First Name, Middle Name, Last Name, FolderName
Mr, John, Aldo, Smith,MFA1002
Any suggestions greatly appreciated.
Thanks
Steve
We have been using multiple Outlook contacts folders as a very poor mans CRM system and now want to extract the data and import into a database.
We have the following layout
Contacts
- MFA1001
- MFA1002
- MFA1003
- SSSC1101
- SSSA1107
etc with each sub folder name being the course and date that someone has done.
each folder (including the contacts folder) has 1 to n contacts.
I would like to export all of the contacts into a CSV or Excel file including the folder name as part of the extracted record.
e.g. Title, First Name, Middle Name, Last Name, FolderName
Mr, John, Aldo, Smith,MFA1002
Any suggestions greatly appreciated.
Thanks
Steve
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
StevenAReid: Can you if possible share the vba code so it can helpsomeone in future.
- Rancy
- Rancy
ASKER
Other solutions proposed did not address the requested functionality.
http://email.about.com/od/outlooktips/qt/Export_Outlook_Contacts_to_CSV.htm
How can I export contacts from a particular folder to CSV or PST in Outlook 2011?
http://answers.microsoft.com/en-us/mac/forum/macoffice2011-macoutlook/how-can-i-export-contacts-from-a-particular-folder/4d9c8e49-8255-41c1-bd47-f0ca7a0ed904?tab=MoreHelp
http://www.pcreview.co.uk/forums/export-exchange-outlook-public-folder-contacts-csv-file-t3401376.html
- Rancy