Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
eneleh eneleh is offline
external usenet poster
 
Posts: 1
Default using Japanese addresses in mailmerge yields reverse data

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.
  #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.


  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default using Japanese addresses in mailmerge yields reverse data

There's ausually a strong case for using individual fields as Doug
suggests, but if you are using the ADDRESSBLOCK, it is probably worth
using Alt-F9 to display the field code and see whether the \d and \l
switches are in there. At least one of those settings may have an impact
on how Japanese addresses are displayed. I can't tell you much more than
that, I'm afraid - for example, I don't know how Japnese addresses are
normally laid out in Japan.

AIUI this stuff works better in Word 2007 than it does in Word 2003 but
that's about it.


Peter Jamieson

http://tips.pjmsn.me.uk

On 26/01/2010 00:47, eneleh wrote:
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.

Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mailmerge Japanese and Greek names & addresses in to an english le Plebless Mailmerge 2 October 8th 09 07:31 PM
Undesired Japanese characters in mailmerge Mathijs Mailmerge 1 January 10th 08 09:32 PM
Automating Mailmerge using CSV results in squares / Japanese characters Guabble Mailmerge 3 August 16th 07 03:11 PM
Word should allow Japanese addresses to follow the same format as. Tammy Mailmerge 1 April 21st 05 09:11 AM
Word is typing in reverse and NOTHING addresses this. Mark Ellis Microsoft Word Help 1 February 16th 05 12:29 AM


All times are GMT +1. The time now is 12:11 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"