Mailmerge Word with Excel Source Document

S

Shari

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?
 
D

Doug Robbins

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

--
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
Shari said:
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top