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

Tip: Looking for answers? Try searching our database.

Zeros in empty mail merge field instead of just closing up

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
P. J. - 28 May 2004 13:41 GMT
Hi! When I mail merge address info from an Excel
spreadsheet, the last merge field--empty zip code--does
not close up.  I have two zip code fields: one for
physical address and one for P. O. Boxes.  The last field
shows up as a zero when empty.  I tried setting the Excel
options by unchecking zero, but that doesn't fix the
problem. I've also tried formatting the zip column to text
and number to see if that would fix it, but don't remember
that it fixed the problem.  The zero doesn't really keep
the mail from being delivered, but it would be nice if the
blank field would just disappear as do other empty
fields.  Any information would be greatly appreciated.  I
don't know if this is fixable in Excel or in Word, but
figure it is fixable!  Thanks!

P. J.
Graham Mayor - 28 May 2004 14:43 GMT
It is fixable in Word using a field switch
{Mergefield Zip \# "00000;00000;"}

The above reflects 5 digit Zips - see also
http://www.gmayor.com/formatting_word_fields.htm

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><
Graham Mayor -  Word MVP

My web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>><

> Hi! When I mail merge address info from an Excel
> spreadsheet, the last merge field--empty zip code--does
[quoted text clipped - 12 lines]
>
> P. J.
Charles Kenyon - 28 May 2004 16:27 GMT
Is the cell in Excel formatted as a number rather than as text? If so, I
think it will report a zero value when empty rather than a blank string.
Graham's fix may work for what you want, though.
Signature


Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

> Hi! When I mail merge address info from an Excel
> spreadsheet, the last merge field--empty zip code--does
[quoted text clipped - 12 lines]
>
> P. J.
 
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.