Exporting Other User's Contacts

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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!
 
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


statsman said:
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).
Click to expand...
 
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
 
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
 
guess i'll have to dive into VBA :-S


Sue Mosher said:
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
Click to expand...
 
Back
Top