Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 259
  • Last Modified:

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.
0
pcemsinc
Asked:
pcemsinc
1 Solution
 
jrobillardCommented:
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
0
 
jrobillardCommented:
opt=excel
0
 
AhmedHERMICommented:
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.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
jan24Commented:
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.
0
 
pcemsincAuthor Commented:
I will have to find someone that can write the macros/scripts.
Thanks for the help
0
 
jrobillardCommented:
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
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now