Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / February 2006

Tip: Looking for answers? Try searching our database.

Getting international addresses to format correctly in a mail merg

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
ldgoss - 14 Feb 2006 16:28 GMT
Outlook 2003 seems to understand how to format international address, but
when I do a mail merge for address labels they format incorrectly.  The
particular problem is where the postal code goes for certain countries.  Here
is an example:

Outlook 2003 (correct):
5009  Cordoba
Argentina

Mail merge (incorrect):
Cordoba 5009
Argentina

I am using the insert address block to format the address and the, "Format
address according to the destination/region" checked.
Peter Jamieson - 14 Feb 2006 17:46 GMT
I'm sure Word's international formatting is better than when I last looked,
but as you say it certainly reverses the code and city in the case you
mention and perhaps others. When I last looked at how Outlook worked with
addresses, I concluded that only a small number of "patterns" were in use
worldwide (I think it was only 5 or 6), and I have to conclude that Outlook
either usually or always gets it right but that Word sometimes gets it
wrong.

I suspect that the only things you can do are
a. report the problem to Microsoft, e.g. by e-mailing mswish@microsoft.com
(don't expect anything to be fixed, though!)
b. use individual fields rather than the Addressblock, at least for those
countries where you know Word gets it wrong. Graham Mayor has relevant pages
on his website that should help you here:

http://www.gmayor.com/mail_merge_labels_with_word_xp.htm  and
http://www.gmayor.com/formatting_word_fields.htm

Peter Jamieson

> Outlook 2003 seems to understand how to format international address, but
> when I do a mail merge for address labels they format incorrectly.  The
[quoted text clipped - 12 lines]
> I am using the insert address block to format the address and the, "Format
> address according to the destination/region" checked.
Doug Robbins - Word MVP - 14 Feb 2006 19:05 GMT
Don't use the Address Block.  Just insert the individual merge fields that
you want to use in the configuration that YOU want them.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Outlook 2003 seems to understand how to format international address, but
> when I do a mail merge for address labels they format incorrectly.  The
[quoted text clipped - 12 lines]
> I am using the insert address block to format the address and the, "Format
> address according to the destination/region" checked.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.