Word 200 Mail Merge - Insert Blank Page for Duplexing

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Anne-Marie Norman - 05 Jun 2004 19:17 GMT

(Type your message here)
Hello,

I have Access 2000 data that is merged into Word 2000. Each Access table is merged to a specific main Word document. Each main document has several If statements. Based upon the selection of various Access fields and checkboxes, specific text is output to the Word main document. The amount of output text affects the number of pages each record produces. For example, one record may require a two page letter, while the next record may require three pages, etc. My dilemma is that I need the merged document to be able to print duplex. If I have a record that produces one page, I do not want the next record to start printing on the back page of record one. Basically, I want to insert a blank page when needed. I experimented with different types of breaks but it does not work for every record. Is there a way to do this when the source records produce varying numbers of section break pages within the same document? Please help. I have been researching/experimenting with this for weeks. Thank you.

--------------------------------
From: Anne-Marie Norman

-----------------------
Posted by a user from AdminLife (http://www.adminlife.com/)

<Id>KJ6+s7KJ8EOFiqGeIrWrOg==</Id

Reply to this Message

Doug Robbins - Word MVP - 05 Jun 2004 23:25 GMT

If you use the following macro on the document created by the mailmerge, it
will send each letter to printer as a separate print job, which will
probably achieve what you are after

Dim i As Long
For i = 1 To ActiveDocument.Sections.Count
ActiveDocument.PrintOut Range:=wdPrintFromTo, From:="s" & i, To:="s" & i
Next i

Signature

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

(Type your message here)
Hello,

I have Access 2000 data that is merged into Word 2000. Each Access table is
merged to a specific main Word document. Each main document has several If
statements. Based upon the selection of various Access fields and
checkboxes, specific text is output to the Word main document. The amount
of output text affects the number of pages each record produces. For
example, one record may require a two page letter, while the next record may
require three pages, etc. My dilemma is that I need the merged document to
be able to print duplex. If I have a record that produces one page, I do
not want the next record to start printing on the back page of record one.
Basically, I want to insert a blank page when needed. I experimented with
different types of breaks but it does not work for every record. Is there a
way to do this when the source records produce varying numbers of section
break pages within the same document? Please help. I have been
researching/experimenting with this for weeks. Thank you.

--------------------------------
From: Anne-Marie Norman

-----------------------
Posted by a user from AdminLife (http://www.adminlife.com/)

<Id>KJ6+s7KJ8EOFiqGeIrWrOg==</Id

Reply to this Message