Exporting Other User's Contacts

[Delores Elias]

Is there a way to export another user's contacts without having to sit at
that user's workstation? We have a mailing that will be sent out every month
and we will need to access other users' contacts to get the most updated
email addresses.

 

[Sue Mosher [MVP-Outlook]]

Why not run a mailmerge from that folder using Outlook's Tools | Mail Merge command?

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[statsman]

But to return to the question, is there a way to export another person's
shared contacts? I'm doing more than a mailmerge, and need to put it into
either access or excel (from which it goes to access).

Thanks!

 

[Sue Mosher [MVP-Outlook]]

If you're doing more than a mail merge, why did you imply in your original post that all you needed were the email addresses for a mailing?

Regardless, the answer is the same. If you perform a mail merge using the category format and put commas or another delimiter between the fields, you can easily save as a .csv or .txt file and import into Access or Excel.

Copy and paste from a table view to Excel is also an option.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

But to return to the question, is there a way to export another person's
shared contacts? I'm doing more than a mailmerge, and need to put it into
either access or excel (from which it goes to access).

 

[IvKo]

http://www.imibo.com/imidev/Exchange/imice.htm

IMI Contacts Exporter for Microsoft Exchange Server is specially designed
for Microsoft Outlook users to export Contacts from any Outlook and/or
Exchange Public Contacts Folder (or private Mailbox folder) to MS Access
2000 table or MS Excel file.

http://www.imibo.com/imidev/Exchange/imice.htm

 

[Martin]

But to get back to the original question....

Is it possible to export shared contacts or contacts stored in public folders?
Not using external programs.

Martin

 

[Sue Mosher [MVP-Outlook]]

Yes, either by writing Outlook VBA code or by copying them into a folder in your own mailbox or a .pst file and exporting from that folder.

I'd still recommend a mail merge, with which you can create a .csv file that either Access or Excel can use.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Martin]

guess i'll have to dive into VBA :-S

Yes, either by writing Outlook VBA code or by copying them into a folder in your own mailbox or a .pst file and exporting from that folder.

I'd still recommend a mail merge, with which you can create a .csv file that either Access or Excel can use.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers