Sergy Stouk
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.
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.
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.
ASKER
It would be perfect if macro could do it.
How do I create a macro in Outlook?
How do I create a macro in Outlook?
ASKER
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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?
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?
ASKER
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.
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.
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