Outlook "Mailing Address" option

[Guest]

I have marked contacts with the mailing address check mark (some home and
some business addresses). Now I want to export the "mailig address" to Excel
and cannot do that using mapped fields.

But I do get "mailing address" info if I do a mail merge into Word.

I really need whatever I've marked as "mailing address" into an Excel sheet
without lots of copying and pasting.

Help please!

 

[Sue Mosher [MVP-Outlook]]

Do a mail merge to Word, using the catalog format, and putting commas between fields. Save it as a text file, with a .csv extension, and Excel will open it nicely.
--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Guest]

thanks for the quick response I will try that.

Do a mail merge to Word, using the catalog format, and putting commas between fields. Save it as a text file, with a .csv extension, and Excel will open it nicely.
--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers