Skipping records when merging to print

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

litldill - 09 Aug 2007 00:08 GMT

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.

Signature

Litldill

Reply to this Message

Doug Robbins - Word MVP - 09 Aug 2007 10:19 GMT

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

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 have a large excel database that merges into a word doc so that each
>record
[quoted text clipped - 6 lines]
> between and skips the odd numbered record. I am at a loss...any thoughts
> would be appreciated.

Reply to this Message

litldill - 10 Aug 2007 18:06 GMT

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?

Signature

Litldill

> Do you have a <<Next Record>> field anywhere in the mail merge main
> documnet?
[quoted text clipped - 9 lines]
> > between and skips the odd numbered record. I am at a loss...any thoughts
> > would be appreciated.

Reply to this Message

litldill - 10 Aug 2007 18:14 GMT

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

Signature

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.
[quoted text clipped - 23 lines]
> > > between and skips the odd numbered record. I am at a loss...any thoughts
> > > would be appreciated.

Reply to this Message

Doug Robbins - Word MVP - 10 Aug 2007 22:30 GMT

Delete the <<Next Record>> field. It 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

> 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.
[quoted text clipped - 28 lines]
>> > thoughts
>> > would be appreciated.

Reply to this Message