Address Layout

[Frances Thorn]

Results of my research indicate that Canada Post and US
Mail have guidelines for address layout which ensure
fastest processing. Example:

JOHN CONSUMER
545 MAXIMUM ROAD
BIGCITY ON N7G 5L8

To summarize: all caps, no punctuation, one space between
city and province and two spaces between province and
postal code.

Has anyone found a way when using MS Word Mail Merge to
eliminate that comma after the city? The address block
seems to include it and there is a comma inserted in the
contact entry box for individual contacts. US Mail
parameters are similar.

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

See changing the address layout at
http://www.slipstick.com/contacts/insword.htm

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP

 

[Graham Mayor]

You don't have to use the address block - set the fields you want and their
format directly in the mail merge document
eg
{Mergefield First_Name \* Upper} {Mergefield Last_Name \* Upper}
{Mergefield Street \*Upper}
{Mergefield City \*Upper} {Mergefield State \*Upper} {Mergefield Zip}

Change the field names to reflect the data source. See also
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail (e-mail address removed)
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

 

[Peter Jamieson]

If you use Alt-F9 to display the field code for the ADDRESSBLOCK you should
see a number of components such as <<_STATE_>> etc. You will probably see a
comma inside the <<>> surrounding _CITY_ or _STATE_. If so, delete it. But
bear in mind:
a. editing the ADDRESSBLOCK code directly is not recommended by Microsoft
(which is probably why they have not published a specification as to what
<<_ITEM_>> fields are available etc.), possibly because...
b. if you use the standard ADDRESSBLOCK properties option to specify the
layout and content, any edits you made will be lost.

Roughly speaking, anything inside the <<>> is displayed/printed if the named
item (_CITY_) etc. is non-blank, but not otherwise. Anything outside the
<<>> is always displayed. (It's a bt more complicated than that for the frst
line of the addressblock).