Exporting Outlook Mailing Address to Excel ?

[emailus]

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

 

[Brian Tillman]

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

Since there is no "Mailing Address" field in Outlook (there's Business
Address, Home Address, and Other Address), you can't have the export choose
which of those addresses to use, if the mailing address varies between them.
I think the best approach would be to export them all and then dit the Excel
file to remove the addresses that are not the mailing address, renaming one
of the columns to have the heading the fulfillment house requires, placing
the retained addresses in that column.

 

[Diane Poremsky [MVP]]

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.

 

[emailus]

Since there is no "Mailing Address" field in Outlook (there's Business
Address, Home Address, and Other Address), you can't have the export choose
which of those addresses to use, if the mailing address varies between them.
I think the best approach would be to export them all and then dit the Excel
file to remove the addresses that are not the mailing address, renaming one
of the columns to have the heading the fulfillment house requires, placing
the retained addresses in that column.

Thanks Brian. The problem here is that there are over 2,000 entries.
If I export from Outlook to Excel as you suggest, the Excel result
will not include any mailing address indictor. If it did, then I could
perhaps build in some kind of IF statement to achieve the desired
result, but without a mailing address indictor being carried through
to Excel, I still have a very labour intensive exercise at hand.

Unless somehow the Mailing Address indicator from Outlook can be
exported through to Excel?

Cheers, Steven

 

[Brian Tillman]

Unless somehow the Mailing Address indicator from Outlook can be
exported through to Excel?

I don't know of any way to do that. There are plenty of people more
knowledgeable than I in this group and maybe it's possible with VBA code.
One of those people may be able to say.