Mail Merge is not complete

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Judi - 07 Aug 2003 21:34 GMT

I have created an excell spreadsheet with 181 entries in
it. When I look at the sheet on the mailmerge toolbar, it
sees all 181 entries....the problem is that when I merge,
I only get 172 labels?!? No dups, what's with this?

thanks for your help!

Judi

Reply to this Message

Doug Robbins - Word MVP - 08 Aug 2003 08:27 GMT

Hi Judi,

Do you have a <<Next Record>> field in the first cell of the mailmerge main
document? If so, delete it.

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

> I have created an excell spreadsheet with 181 entries in
> it. When I look at the sheet on the mailmerge toolbar, it
[quoted text clipped - 4 lines]
>
> Judi

Reply to this Message

Cindy Meister -WordMVP- - 08 Aug 2003 10:43 GMT

Hi Judi,

> I have created an excell spreadsheet with 181 entries in
> it. When I look at the sheet on the mailmerge toolbar, it
> sees all 181 entries....the problem is that when I merge,
> I only get 172 labels?!? No dups, what's with this?

1) Which version of Word are we dealing with
2) How many labels are on a sheet (IOW how many pages is mail
merge generating)
3) Can you identify any pattern to the records that are being
missed?

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

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail :-)

Reply to this Message