View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default using Japanese addresses in mailmerge yields reverse data

I guess that you are using the Address Block field. Instead of doing that,
just insert the actual merge fields in the configuration that you want them.

However, if the data has been entered incorrectly in the data source, you
will either have to correct it or you maybe able to work around it by using
an If...then...Else field construction that checks for the country Japan in
what ever field that it is appearing in and then uses a configuration of
merge fields that gives the desired result in that case, or uses a different
configuration if the country is not Japan.

{ IF { MERGEFIELD nameoffieldthatreturnsJapan } = "Japan" "{ MERGEFIELD
firstmergefieldforJapanaddress}¶
{ MERGEFIELD secondmergefieldforJapanaddress }¶
....¶
{ MERGEFIELD lastmergefieldforJapanaddress }" "{ MERGEFIELD
firstmergefieldfornonJapanaddress }¶
{ MERGEFIELD secondmergefieldfornonJapanaddress }¶
....¶
{ MERGEFIELD lastmergefieldfornonJapanaddress }" }

You must use Ctrl+F9 to insert each pair of field delimiters { } and where
the ¶ appears in the above, press the enter key.

--
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, originally posted via msnews.microsoft.com

"eneleh" wrote in message
...
all addresses in the excel sheet work with mail merge in word, but the
japanese addresses come out in reverse order: name, company, city, country
the exact reverse of all other addresses in the sheet.