Mailmerge Word with Excel Source Document

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Shari - 13 Jul 2004 20:44 GMT

I have set up four tables per page in a Word Document. I am trying to merge 70 records from Excel into the tables. Instead of getting records 1 - 4 on page one and 5 -8 on page 2 etc... I am getting one record in all four tables on each page, basically I end up with 70 pages. Record one is in all four tables on page one, record two is in all four tables on page two and so on. Can anyone help?

Reply to this Message

Doug Robbins - 14 Jul 2004 03:40 GMT

Insert a <<Next Record>> field before the first mergefield in each of the
second, third and fourth tables in the main documnet.

Signature

Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

> I have set up four tables per page in a Word Document. I am trying to merge 70 records from Excel into the tables. Instead of getting records 1 -

4 on page one and 5 -8 on page 2 etc... I am getting one record in all four
tables on each page, basically I end up with 70 pages. Record one is in all
four tables on page one, record two is in all four tables on page two and so
on. Can anyone help?

Reply to this Message

Rate this thread: