Exporting Mailing Address to Excel

[Guest]

I have a client who is using Outlook 2003 and Word 2002. She wants to do a
mail merge with her Outlook contacts, but since her software versions are
different, she has to export her contacts to an Excel file and use that as
the data source.

Her contacts have multiple addresses and for the purposes of her mail merge,
she needs to know which address is the mailing address (it may be the
Business address for one and the Home address for another). When "Mapping
Custom Fields" in the export wizard, "Mailing Address" isn't available to
choose from. Is there a way to get this information into the Excel
spreadsheet?

 

[Russ Valentine [MVP-Outlook]]

Use the individual address elements (not one of the derived fields) to
construct the merge.