Why do Zeros appear?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lesley W - 29 Apr 2004 02:46 GMT

I am using Word 2002 and an Excel 2002 spreadsheet to produce mailing labels. If there is no data in a field I get a 0 appearing in the merged doucment. In my fields for post codes, if I have, say, a country's name typed there instead of a post code, then this does not appear in the merged document at all. I must say I have been using mail merges for the past 15 years and find this version is one of the most frustrating and limiting ever produced.
A similar problem occured when I was using mail merge to produce a directory and got a 0 at the end of every set of records which I then had to remove using "search and replace" - a waste of my precious time
I would really appreciate some help with this. Thank

Reply to this Message

Graham Mayor - 29 Apr 2004 10:08 GMT

Microsoft has changed the way a merge document connects to its data - see
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm which should put
you back on track.

Signature

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

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

> I am using Word 2002 and an Excel 2002 spreadsheet to produce mailing
> labels. If there is no data in a field I get a 0 appearing in the
[quoted text clipped - 7 lines]
> "search and replace" - a waste of my precious time!
> I would really appreciate some help with this. Thanks

Reply to this Message

Lesley W - 30 Apr 2004 01:41 GMT

Thank you - I can now get my mail merges to work properly! Another question if I may - with a directory, how can I prevent a set of records from splitting over onto the next page? I s there some way of formatting so that if this is going to happen the entire record (the largest in this instance was 5 lines) will automatically move to the next page? Sort of like paragraph widow/ophans I guess?

Reply to this Message

Doug Robbins - Word MVP - 30 Apr 2004 06:51 GMT

If the merge fields are all in a single paragraph, format that paragraph in
the mail merge main document so that the lines are kept together. If they
are in multiple paragraphs, format all but the last one so that the
paragraphs a kept with the next.

Signature

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

> Thank you - I can now get my mail merges to work properly! Another question if I may - with a directory, how can I prevent a set of records

from splitting over onto the next page? I s there some way of formatting so
that if this is going to happen the entire record (the largest in this
instance was 5 lines) will automatically move to the next page? Sort of like
paragraph widow/ophans I guess?

Reply to this Message

Rate this thread: