On Apr 28, 8:00*pm, "Brian Tillman" wrote:
wrote:
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.
--
Brian Tillman [MVP-Outlook]

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