how do i mail-merge 3 records per page in duplex?

[janet]

i need to create a 3 up duplex mail merge document. i have to print the same
3 records information on the front and the back of my form. for example:
records 1,2,3 name and address on the front and record 1,2,3 office address
on the back. if put in "next record", it will start at record #4 on the back
page. I can't figure out if there is a way to start with record 1,2,3 again
on the back. this is a large data file i am working with. please help. thanks.

 

[Doug Robbins]

I assume that you have a printer that can duplex print.

There is no way that you can do this in a single operation with mailmerge.
You will need to create two mailmerge main documents, one for the
information and one for the addresses, both of which use the same data
source. Then you will need to execute each of these mailmerges to a new
document, saving each of those documents.

Then, if you run a macro containing the following code, it will show you the
File>Open dialog at which point you need to open the appropriate document
created by the mailmerge operation (the one containing the information
first, then the one containing the address details. It will then create a
new document that combines the information from the information and the
address documents in what should be the correct order to allow you to
produce the duplex printed document that you are after.

While I believe the macro to be correct, I have not tested it

Dim A As Document, B As Document, Target As Document
Dim Arange As Range, Brange As Range
Dim i As Long
'Open the information document - replace [path\filename] with the
path\filename
'for the document created by the first mailmerge.
Set A = Documents.Open("[path\filename]")
'Open the address document - replace [path\filename] with the path\filename
'for the document created by the first mailmerge.
Set B = Documents.Open("[path\filename]")
Set Target = Documents.New
For i = 1 To A.Sections.Count
Set Arange = A.Sections(i).Range
Arange.End = Arange.End - 1
Set Brange = B.Sections(i).Range
Brange.End = Brange.End - 1
Target.Range.InsertAfter Arange.Text
Target.Range.InsertAfter Brange.Text
Next i


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

 

[Graham Mayor]

You can't do this with Word. Word will not 'go back' into the data. You will
either have to create a data file in which the records are duplicated in
threes ie 123 123 456 456 or create separate merges for front and back.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Ed Katzman]

i need to create a 3 up duplex mail merge document. i have to print the same
3 records information on the front and the back of my form. for example:
records 1,2,3 name and address on the front and record 1,2,3 office address
on the back. if put in "next record", it will start at record #4 on the back
page. I can't figure out if there is a way to start with record 1,2,3 again
on the back. this is a large data file i am working with. please help. thanks.

It can be done.

Set up the merge document for the front of the page as you normally
would, some thing like:
<<Name>>
<<Address>>
<<Next Record>>

<<Name>>
<<Address>>
<<Next Record>>

<<Name>>
<<Address>>
<<Next Record>>

Now select the first name and address block and use Insert --> Bookmark
and give it a name, say LabelOne. Do the same with the other two
address blocks, giving them their own bookmark names.

Now for the back: On this page, rather than using the merge information
directly, we'll use the bookmarks.

To get the first name and address block, use Insert --> Field, scroll
down to Ref and select it under Field Names, and then choose LabelOne
from the Bookmark name column.

Repeat this for the other two bookmarks.

Done.

Ed

 

[Ed Katzman]

It can be done.

Set up the merge document for the front of the page as you normally
would, some thing like:
<<Name>>
<<Address>>
<<Next Record>>

<<Name>>
<<Address>>
<<Next Record>>

<<Name>>
<<Address>>
<<Next Record>>

Now select the first name and address block and use Insert --> Bookmark
and give it a name, say LabelOne. Do the same with the other two
address blocks, giving them their own bookmark names.

Now for the back: On this page, rather than using the merge information
directly, we'll use the bookmarks.

To get the first name and address block, use Insert --> Field, scroll
down to Ref and select it under Field Names, and then choose LabelOne
from the Bookmark name column.

Repeat this for the other two bookmarks.

Done.

Ed

I reread your question and see that you may want different info on the
back.

No problem. To put home address on the front and office on the back,
Set up page one with blocks like:

<<name>>
<<Address>>
<<Officeaddress>>
<<Next Record>>

and format the <<office address>> as "hidden" (Format --> Font , check
Hidden box) so it doesn't print on the front, but we've gotten it from
the record before moving on to <<Next Record>>.

Now, apply the bookmark only to the part of the entry that you want on
the back, all of it or just the hidden part.

Insert the bookmark on page two as I said above, with one caution:

Be sure that when you put <<Ref LabelOne>> you don't check "Preserve
formatting" so the gidden text attribute doesn't carry over to the back.

Now you have Name & Address on the front, Office address on theback.

Ed