 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Outlook / Contacts / August 2006Exporting Other User's Contacts
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?  SignatureSue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx > 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. 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! > Why not run a mailmerge from that folder using Outlook's Tools | Mail Merge command? > > > 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. 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. SignatureSue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx > 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! > [quoted text clipped - 4 lines] >> > and we will need to access other users' contacts to get the most updated >> > email addresses. 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 > 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 [quoted text clipped - 8 lines] > > > and we will need to access other users' contacts to get the most updated > > > email addresses. 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 > http://www.imibo.com/imidev/Exchange/imice.htm > [quoted text clipped - 22 lines] > updated > > > > email addresses. 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. SignatureSue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx > But to get back to the original question.... > [quoted text clipped - 30 lines] >> updated >> > > > email addresses. 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. > [quoted text clipped - 34 lines] > >> updated > >> > > > email addresses. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.