HELP! Mailmerge only merging even numbered lines from spreadsheet.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MichelleRL - 22 Mar 2006 19:58 GMT

I'm working on a 200-item/40 page catalog (due tonight of course), and all's
gone just fine until I hit "merge document". It's only merging the even
numbered lines of the spreadsheet. HELP! I did not put any filters/options on
the document. Been using Mailmerge for years, never had this problem before.
Database is in Excel 2002, Word is 2002. Any help to merge the whole document
is greatly appreciated!

Reply to this Message

Doug Robbins - Word MVP - 22 Mar 2006 20:06 GMT

Sounds like you have a <<Next Record>> field in the main document where one
is not required.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> I'm working on a 200-item/40 page catalog (due tonight of course), and
> all's
[quoted text clipped - 6 lines]
> document
> is greatly appreciated!

Reply to this Message

Doug Robbins - Word MVP - 22 Mar 2006 20:07 GMT

And, if it is only merging the even numbered records, then it sounds like it
is before the first merge field in the document.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> I'm working on a 200-item/40 page catalog (due tonight of course), and
> all's
[quoted text clipped - 6 lines]
> document
> is greatly appreciated!

Reply to this Message

MichelleRL - 22 Mar 2006 21:23 GMT

THANK YOU! Duh!?! So simple, you saved my sanity today.

:-)

> And, if it is only merging the even numbered records, then it sounds like it
> is before the first merge field in the document.
[quoted text clipped - 9 lines]
> > document
> > is greatly appreciated!

Reply to this Message