merge outlook field 'mailing address' to excel or into a table?

[SusieMc]

I want to create a list from Outlook to include only Full Name, Mailing
Address (not any of the other addresses), and perhaps phone or email. The
problem I am having is that 'Mailing Address' is not actually a FIELD in
outlook. It is a conglomeration of several fields (Add Line 1, Add Line 2,
Suburb, State, Postcode, Country) and to make it even more complicated, the
mailing address is the one that is indicated by a tick for either Business,
Home, or Other. I can't seem to find a way. Note: This is not for a mailing,
but to just have a list showing the mailing address.

 

[Judy Gleeson MVP - Outlook]

No it's not that difficult. There is a field called Mailing Address. You
can use it.

Change the view of your Contacts to Phone List and use the field chooser to
find the Mailing Address field. Then you can print that table view with
the field showing.

Judy Gleeson - MVP Outlook
Acorn Training and Consulting
Canberra, Australia


see what Outlook training can do to improve productivity:
www.acorntraining.com.au/pdfdocs/ProductivITwithOutlook.pps

www.acorntraining.com.au/productivit.htm