Skipping records when merging to print

[litldill]

I have a large excel database that merges into a word doc so that each record
creates two pages to print (broken into 1 section for each two page record).
I can merge to a new doc and view the pages of each section without issue but
when asking to print specific records (i.e. 40-80) it prints a blank page in
between and skips the odd numbered record. I am at a loss...any thoughts
would be appreciated.

 

[Doug Robbins - Word MVP]

Do you have a <<Next Record>> field anywhere in the mail merge main
documnet?

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

 

[litldill]

Yes, first thing. This was set up by another user but done in a complex
manner. It thinks it is linked to sql. somewhere which I dont have.

When I open the excel source data it shows me a select table that looks like
this:
'2004$'
'2004'$Print_Area
'2004'$Print_Titles
but the only one I can select is the first one.
I only have one table (albeit large) and cannot find a way to edit the print
area or delete it. It is not in the normal setup.

Do you think I may need to re-create the main document?

 

[litldill]

I forgot to add that I can merge a single record at a time without an issue.

 

[Doug Robbins - Word MVP]

Delete the <<Next Record>> field. It is not required.

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