Link to home
Start Free TrialLog in
Avatar of Sergy Stouk
Sergy StoukFlag for Canada

asked on

Export Contacts and Calendar to .csv from Outlook

Is there a utility or tool or a script example that would allow user to automatically dump their Contacts and Calendar information into a csv file?

We need something as simple as a click/double-click of a button, which will make such export based on the pre-determined configuration into a network-mapped drive.
Avatar of sunray_2003
sunray_2003
Flag of United States of America image

easiest for me is to go to file > import and export and do that way ..

Otherwise , you might be doing something like a VBA code or spending money on outlook add-ins.. Do you mind spending money ?
as far as I have searched, could not find anything specific but let me know what you plan to do .

some places where you can search

http://www.mapilab.com/outlook/?ga

http://www.slipstick.com/addins/contacts.htm 
In outlook go to File>Import and Export.  Click on Export to a file and next Click on Comma Seperated Valu and next, Select what you want to export and click on next.
You should be able to create a macro to do this and create a button to put on your menues to run the macro like you would in word.  If you need more help with that let us know.
Avatar of Sergy Stouk

ASKER

It would be perfect if macro could do it.
How do I create a macro in Outlook?
Actually, I am reading a help doc on how to create macto rigth now.
But some example of working with Calendar and Contacts with macro could be helpful.
Thank You for your attention to this question.
ASKER CERTIFIED SOLUTION
Avatar of sunray_2003
sunray_2003
Flag of United States of America 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
There is no proper vbs or wmi example under
http://www.outlookcode.com/d/vb.htm
In fact, I am still looking for a script example to do the job.
At this point I would be even satisfied with some utility that I would purchase, which could allow me to extract such information from multiple .pst exports from MS Exchange.
I could use "exmerge.exe" and export end-user exchange documents into .pst file.
I will need something to open those archive and extract Contacts and Calendar information from all users in an Automated manner.
Any further suggesstions?


There is no easy a viable solution for this.
Programming department has to be involved and it is more than the department could afford.
We abandoned the project

If you come across a licensed version of the utility, which might do this - let me know.