View Single Post
  #3  
Old April 28th 08, 02:30 PM posted to microsoft.public.outlook
Diane Poremsky [MVP]
external usenet poster
 
Posts: 5,618
Default Exporting Outlook Mailing Address to Excel ?

if the mailing address field won't export, create a table view that contains
it and copy and paste into excel.
http://www.outlook-tips.net/howto/copy_data.htm

why are you trying to map fields on the export? just let outlook export to a
new xls and be done with it - delete fields from the export as needed.



--
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:


Outlook Tips:
http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Subscribe to Exchange Messaging Outlook newsletter:




wrote in message
...
I'm using Office 2003 on Windows XP.

I have an Outlook contact database in which individual contacts may
have more than one address, with the mailing address indicated via the
"This Is The Mailing Address" indicator.

However, when I try to export some basic details to Excel from
Outlook, via Outlook's "Export To A File" function, when I get to "Map
Custom Fields" this area does not appear to give me the option of
stipulating 'Mailing Address'.

Is there a way that I can export just the mailing address from Outlook
to Excel? My problem is that the mailing house which we use will only
accept mailing data in Excel format.

Any tips appreciated.

Steven


Ads
 

Credit Counseling - Remortgage - Personal Loan - Electricity - Wills