Word 200 Mail Merge - Insert Blank Page for Duplexing

[Anne-Marie Norman via AdminLife]

(Type your message here)
Hello,

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

 

[Doug Robbins - Word MVP]

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


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