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 / June 2004

Tip: Looking for answers? Try searching our database.

Post Office & Mail Merge Problem

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
tari - 01 Jun 2004 19:06 GMT
Hi everyone

I use mail merge nearly daily for canvassing & was just notified by my mail sorting company that I can no longer use punctuation in the address block as the new sorting machines don't recognize punctuation....I can't find a way to remove it in the address block, any ideas?????  Thanks & I'll surf your problems to see if I can help you with any problems....thanks again!!  Tari
Peter Jamieson - 01 Jun 2004 22:40 GMT
The addressblock doesn't give you a lot of control over the formatting.

You can use alt-F9 to reveal the ADDRESSBLOCK field codes.

You should see various "address elements" such as <<_CITY_>>. Where you see
punctuation such as "," /inside/ the << >>, that punctuation should only be
applied when (e.g.) _CITY_ is non-blank. When you see punctuation /outside
the << >>, that punctuation should always appear.

So in theory you can get rid of most punctuation by removing it from within
the ADDRESSBLOCK. Unfortunately
a. you can edit the ADDRESSBLOCK content directly, but if you ever use
Word's standard features to alter the content of the ADDRESSBLOCK or modify
the field mappings, Word will re-impose a standard ADDRESSBLOCK layout and
overwrite your changes
b. some punctuation may be inserted by ADDRESSBLOCK (as far as I know, it
is only in the first line) whatever you do.

The alternative is to use individual field codes { MERGEFIELD city } or
whatever, nested within IF fields if you need to include some fields
conditionally.

I don't know the rules for address layout everywhere (I am in the U.K.) but
if you are in the U.S.A. I find it slightly strange that your mal sorting
company would not recognise
a. punctuation in address lines submitted by (e.g.) your customers, who
ought to know their own addresses
b. punctuation in the City, State ZIP line (which seems until fairly
recently to have had a comma as standard, and I must say I thought it was a
USPostal Service Standard, but maybe not)

Signature

Peter Jamieson

> Hi everyone,
>
> I use mail merge nearly daily for canvassing & was just notified by my mail sorting company that I can no longer use punctuation in the address
block as the new sorting machines don't recognize punctuation....I can't
find a way to remove it in the address block, any ideas?????  Thanks & I'll
surf your problems to see if I can help you with any problems....thanks
again!!  Tari
Cindy M  -WordMVP- - 02 Jun 2004 15:15 GMT
Hi =?Utf-8?B?dGFyaQ==?=,

> I use mail merge nearly daily for canvassing & was just notified by my mail sorting company that I can no longer use punctuation in the address block as the new sorting
machines don't recognize punctuation....I can't find a way to remove it in the address
block

I concur with everything Peter says. Just one additional suggestion:

Once you have an AddressBlock field code that's working, select it and save it as an
AutoText entry. Then you should be able to reuse it without having to continuously jump
through all the hoops again.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply in the
newsgroup and not by e-mail :-)
 
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.