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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SusieMc - 12 Oct 2005 08:32 GMT

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.

Reply to this Message

Judy Gleeson MVP - Outlook - 13 Oct 2005 00:31 GMT

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

> 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
[quoted text clipped - 4 lines]
> 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.

Reply to this Message