[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.
--
Litldill

[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" wrote in message
...
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.
--
Litldill

[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


"Doug Robbins - Word MVP" wrote:

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" wrote in message
...
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.
--
Litldill

[litldill]

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


"litldill" wrote:

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


"Doug Robbins - Word MVP" wrote:

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" wrote in message
...
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.
--
Litldill

[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

"litldill" wrote in message
...
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


"Doug Robbins - Word MVP" wrote:

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" wrote in message
...
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.
--
Litldill