Link to home
Start Free TrialLog in
Avatar of Steven Reid
Steven ReidFlag for Australia

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
Avatar of Manpreet SIngh Khatra
Manpreet SIngh Khatra
Flag of India image

ASKER CERTIFIED SOLUTION
Avatar of Steven Reid
Steven Reid
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
StevenAReid: Can you if possible share the vba code so it can helpsomeone in future.

- Rancy
Avatar of Steven Reid

ASKER

Other solutions proposed did not address the requested functionality.