 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / August 2005International Addresses
I am performing a mail merge using Contacts that were exported to a CSV file. The contacts contain US, European and Asian addresses. I'm using the AddressBlock field and matching the appropriate fields to be merged. The merge completes, but the Asian (Japan) addresses are formatted incorrectly. The European (Germany) and US addresses are formatted correctly. The Japan address should be formatted exactly as a US address (see samples below), but when merged the Country is on the 1st line, Zip on the 2nd line which is incorrect. [US/Japan Sample Address Formatting] John Doe Doe Company President 123 Any Street Washington, DC 20004 Country [Germany Sample Address Formatting] Doe Company Herrn John Doe 123 Any Street 20004 Munich Germany Don't use the AddressBlock. Just insert the individual mergefields in the configuration that you require.  SignatureHope 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 >I am performing a mail merge using Contacts that were exported to a CSV >file. [quoted text clipped - 24 lines] > 20004 Munich > Germany If individual merge fields are used, the Asian addresses do not format properly; only the US and Germany addresses format properly. > Don't use the AddressBlock. Just insert the individual mergefields in the > configuration that you require. [quoted text clipped - 27 lines] > > 20004 Munich > > Germany In what way are they not formatted properly? SignatureHope 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 > If individual merge fields are used, the Asian addresses do not format > properly; only the US and Germany addresses format properly. [quoted text clipped - 34 lines] >> > 20004 Munich >> > Germany Asian addresses format with the Country as the first line of the address, the postal code is the 2nd line of the address, Country and street address are the 3rd and 4th lines of the address and, the person's name is the last line of the address. > In what way are they not formatted properly? > [quoted text clipped - 36 lines] > >> > 20004 Munich > >> > Germany Not in the Asian country in which I lived for 11 years, but of course there are many Asian countries. As I see it, you have two choices, re-arrange the data in the datasource based on the country of destination, Use a series of If...then...else fields that check for the destination country (a real pain if there a multiple countries that meet the criteria you set) and then insert the appropriate mergefield in the arrangement that you consider correct. I would opt for the first solution. SignatureHope 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 > Asian addresses format with the Country as the first line of the address, > the [quoted text clipped - 47 lines] >> >> > 20004 Munich >> >> > Germany Thank you Doug for your assistance. I'll try both. (FYI -- Germany is the country that forms their addresses differently; the Asian address format is the same as the US) > Not in the Asian country in which I lived for 11 years, but of course there > are many Asian countries. [quoted text clipped - 60 lines] > >> >> > 20004 Munich > >> >> > Germany
|
Reply to this Message |
 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.