How do I export Multiple Contacts folders from outlook 2007 to Excel

I have a Law office client that wants their outlook contacts (many Folders) setup in an Excel file so they may print copies for all office staff.
I can export 1 folder at a time, but there are over 100 folders with many entries in each. Then I have to somehow combine over 100 .xls files together.
Who is Participating?

Improve company productivity with a Business Account.Sign Up

jan24Connect With a Mentor Commented:
I don't know of any built-in feature that would do this, so it's a question of writing some macros that achieve what you want.  You need two stages:
1) An Outlook macro that goes through the 100 contacts folders and exports to CSV files
2) An Excel macro that reads the CSV files and combines them.
save them as an csv file instead of excel format (xls)
then in msdos windows
type *.csv > C:\import.csv
then re-open-it in opt
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

1. In Outlook, on the File menu, click Import and Export.
2. Click Export to a file, and then click Next.
3. Click Microsoft Excel, and then click Next.
4. In the folder list, click the Contacts folder, and then click Next.
5. Browse to the folder where you want to save the contacts as an Excel file (.xls).
6. Type a name for the exported file, and then click OK.
pcemsincAuthor Commented:
I will have to find someone that can write the macros/scripts.
Thanks for the help
to merge many csv into one
like i told you
in ms-dos console: type *.csv > YouMergingFile.csv

it take about 5 sec to do
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.