Reply
 
Thread Tools Display Modes
  #1   Report Post  
brad572
 
Posts: n/a
Default mail merge 2 x 2 double sided

I am needing to use MS mail merge to create double sided cards which fit 4 to
a page (2 wide by 2 tall) and print mail merge fields on both the front and
back of each card. If I use two mail merge templates then I can get the
printing to go double sided by reloading the paper however the backs don't
line up side to side for the correct entries unless I also rebuild by input
list and change the order(new row order of 2,1,4,3 - pain!!). Does anyone
know how to use a single list input to produce a double sided output in 2 x 2
wide double sided and if possible using the printers double side feature so
the stock does not have to be reloaded and run again?
  #2   Report Post  
Peter Jamieson
 
Posts: n/a
Default

I only know two ways:
a. use a macro to resequence the data - if you search this group for e.g.
"Doug Robbins postcard" (without the quotes) in Google groups you should
find some code by Doug Robbins that will do this for a Word data source.
b. use SET fields to save the values for each card until you need them
again. Unfortunately, this does not wourk with all field types, but for
example, let's assume your data is sequenced correctly for the front side of
the cards and you have a field called myfield.

In a typical one-sided merge you would have:

side 1 row1 column1: (card 1 of 4)

{ MERGEFIELD myfield }

side 1 row1 column2: (card 2 of 4)

{ NEXT }
{ MERGEFIELD myfield }

side 1 row2 column1: (card 3 of 4)

{ NEXT }
{ MERGEFIELD myfield }

side 1 row2 column2: (card 4 of 4)

{ NEXT }
{ MERGEFIELD myfield }

How to modify this depends on whether you can get double-sided printing to
work. To do that, I would try the following:
a. make a page break after the table.
b. copy the contents of the table, paste onto the second page and replace
all the fields with some simple data to test the next two steps (any old
text)
c. go into File|Page Setup and/or your printer driver and do what is
necessary to set up double-sided printing
d. use some ordinary paper and a small amount of test data to test that
double-sided printing works at all, and particularly after the first two
sides

If that works, l then alter page one as follows - there are various ways to
do this but all the {} need to be the special field quotes you can enter
using ctrl-F9.

side 1 row1 column1: (card 1 of 4)

{ SET pc1myfield "{ MERGEFIELD myfield }" }
{ MERGEFIELD myfield }

side 1 row1 column2: (card 2 of 4)

{ NEXT }
{ SET pc2myfield "{ MERGEFIELD myfield }" }
{ MERGEFIELD myfield }

side 1 row2 column1: (card 3 of 4)

{ NEXT }
{ SET pc3myfield "{ MERGEFIELD myfield }" }
{ MERGEFIELD myfield }

side 1 row2 column2: (card 4 of 4)

{ NEXT }
{ SET pc4myfield "{ MERGEFIELD myfield }" }
{ MERGEFIELD myfield }

Then set up page two as follows:

side 2 row1 column1: (card 2 of 4)

{ REF pc2myfield }

side 2 row1 column2: (card 1 of 4)

{ REF pc1myfield }

side 1 row2 column1: (card 4 of 4)

{ REF pc4myfield }

side 1 row2 column2: (card 3 of 4)

{ REF pc3myfield }

Peter Jamieson

"brad572" wrote in message
...
I am needing to use MS mail merge to create double sided cards which fit 4
to
a page (2 wide by 2 tall) and print mail merge fields on both the front
and
back of each card. If I use two mail merge templates then I can get the
printing to go double sided by reloading the paper however the backs don't
line up side to side for the correct entries unless I also rebuild by
input
list and change the order(new row order of 2,1,4,3 - pain!!). Does anyone
know how to use a single list input to produce a double sided output in 2
x 2
wide double sided and if possible using the printers double side feature
so
the stock does not have to be reloaded and run again?



  #3   Report Post  
brad572
 
Posts: n/a
Default

Thank you Peter, it worked wonderful. There was only one issue I had that I
will share here in the event anyone else (that is as novice as I am with
word) ever needs this.

The problem I had was entering the { SET ... } and { REF ....} text. I
tried just typing them in the document however as I discovered you need to
use the mailmerge toolbar item "Insert Word field" and select "Set Bookmark".
Use this for the SET and to get a REF entry do an insert of a SET then go
back and type over the word SET with REF.

Thanks again.

"Peter Jamieson" wrote:

I only know two ways:
a. use a macro to resequence the data - if you search this group for e.g.
"Doug Robbins postcard" (without the quotes) in Google groups you should
find some code by Doug Robbins that will do this for a Word data source.
b. use SET fields to save the values for each card until you need them
again. Unfortunately, this does not wourk with all field types, but for
example, let's assume your data is sequenced correctly for the front side of
the cards and you have a field called myfield.

In a typical one-sided merge you would have:

side 1 row1 column1: (card 1 of 4)

{ MERGEFIELD myfield }

side 1 row1 column2: (card 2 of 4)

{ NEXT }
{ MERGEFIELD myfield }

side 1 row2 column1: (card 3 of 4)

{ NEXT }
{ MERGEFIELD myfield }

side 1 row2 column2: (card 4 of 4)

{ NEXT }
{ MERGEFIELD myfield }

How to modify this depends on whether you can get double-sided printing to
work. To do that, I would try the following:
a. make a page break after the table.
b. copy the contents of the table, paste onto the second page and replace
all the fields with some simple data to test the next two steps (any old
text)
c. go into File|Page Setup and/or your printer driver and do what is
necessary to set up double-sided printing
d. use some ordinary paper and a small amount of test data to test that
double-sided printing works at all, and particularly after the first two
sides

If that works, l then alter page one as follows - there are various ways to
do this but all the {} need to be the special field quotes you can enter
using ctrl-F9.

side 1 row1 column1: (card 1 of 4)

{ SET pc1myfield "{ MERGEFIELD myfield }" }
{ MERGEFIELD myfield }

side 1 row1 column2: (card 2 of 4)

{ NEXT }
{ SET pc2myfield "{ MERGEFIELD myfield }" }
{ MERGEFIELD myfield }

side 1 row2 column1: (card 3 of 4)

{ NEXT }
{ SET pc3myfield "{ MERGEFIELD myfield }" }
{ MERGEFIELD myfield }

side 1 row2 column2: (card 4 of 4)

{ NEXT }
{ SET pc4myfield "{ MERGEFIELD myfield }" }
{ MERGEFIELD myfield }

Then set up page two as follows:

side 2 row1 column1: (card 2 of 4)

{ REF pc2myfield }

side 2 row1 column2: (card 1 of 4)

{ REF pc1myfield }

side 1 row2 column1: (card 4 of 4)

{ REF pc4myfield }

side 1 row2 column2: (card 3 of 4)

{ REF pc3myfield }

Peter Jamieson

"brad572" wrote in message
...
I am needing to use MS mail merge to create double sided cards which fit 4
to
a page (2 wide by 2 tall) and print mail merge fields on both the front
and
back of each card. If I use two mail merge templates then I can get the
printing to go double sided by reloading the paper however the backs don't
line up side to side for the correct entries unless I also rebuild by
input
list and change the order(new row order of 2,1,4,3 - pain!!). Does anyone
know how to use a single list input to produce a double sided output in 2
x 2
wide double sided and if possible using the printers double side feature
so
the stock does not have to be reloaded and run again?




  #4   Report Post  
Peter Jamieson
 
Posts: n/a
Default

Thanks for the feedback - as a matter of fact I think you are the first in
several years to have taken the trouble to report success on this one
(perhaps all the others failed, who knows?) - FWIW you can insert most field
types using ctrl-F9 to insert the special {} and type everything else in the
usual way.

Peter Jamieson
"brad572" wrote in message
...
Thank you Peter, it worked wonderful. There was only one issue I had that
I
will share here in the event anyone else (that is as novice as I am with
word) ever needs this.

The problem I had was entering the { SET ... } and { REF ....} text. I
tried just typing them in the document however as I discovered you need to
use the mailmerge toolbar item "Insert Word field" and select "Set
Bookmark".
Use this for the SET and to get a REF entry do an insert of a SET then go
back and type over the word SET with REF.

Thanks again.

"Peter Jamieson" wrote:

I only know two ways:
a. use a macro to resequence the data - if you search this group for
e.g.
"Doug Robbins postcard" (without the quotes) in Google groups you should
find some code by Doug Robbins that will do this for a Word data source.
b. use SET fields to save the values for each card until you need them
again. Unfortunately, this does not wourk with all field types, but for
example, let's assume your data is sequenced correctly for the front side
of
the cards and you have a field called myfield.

In a typical one-sided merge you would have:

side 1 row1 column1: (card 1 of 4)

{ MERGEFIELD myfield }

side 1 row1 column2: (card 2 of 4)

{ NEXT }
{ MERGEFIELD myfield }

side 1 row2 column1: (card 3 of 4)

{ NEXT }
{ MERGEFIELD myfield }

side 1 row2 column2: (card 4 of 4)

{ NEXT }
{ MERGEFIELD myfield }

How to modify this depends on whether you can get double-sided printing
to
work. To do that, I would try the following:
a. make a page break after the table.
b. copy the contents of the table, paste onto the second page and
replace
all the fields with some simple data to test the next two steps (any old
text)
c. go into File|Page Setup and/or your printer driver and do what is
necessary to set up double-sided printing
d. use some ordinary paper and a small amount of test data to test that
double-sided printing works at all, and particularly after the first two
sides

If that works, l then alter page one as follows - there are various ways
to
do this but all the {} need to be the special field quotes you can enter
using ctrl-F9.

side 1 row1 column1: (card 1 of 4)

{ SET pc1myfield "{ MERGEFIELD myfield }" }
{ MERGEFIELD myfield }

side 1 row1 column2: (card 2 of 4)

{ NEXT }
{ SET pc2myfield "{ MERGEFIELD myfield }" }
{ MERGEFIELD myfield }

side 1 row2 column1: (card 3 of 4)

{ NEXT }
{ SET pc3myfield "{ MERGEFIELD myfield }" }
{ MERGEFIELD myfield }

side 1 row2 column2: (card 4 of 4)

{ NEXT }
{ SET pc4myfield "{ MERGEFIELD myfield }" }
{ MERGEFIELD myfield }

Then set up page two as follows:

side 2 row1 column1: (card 2 of 4)

{ REF pc2myfield }

side 2 row1 column2: (card 1 of 4)

{ REF pc1myfield }

side 1 row2 column1: (card 4 of 4)

{ REF pc4myfield }

side 1 row2 column2: (card 3 of 4)

{ REF pc3myfield }

Peter Jamieson

"brad572" wrote in message
...
I am needing to use MS mail merge to create double sided cards which fit
4
to
a page (2 wide by 2 tall) and print mail merge fields on both the front
and
back of each card. If I use two mail merge templates then I can get the
printing to go double sided by reloading the paper however the backs
don't
line up side to side for the correct entries unless I also rebuild by
input
list and change the order(new row order of 2,1,4,3 - pain!!). Does
anyone
know how to use a single list input to produce a double sided output in
2
x 2
wide double sided and if possible using the printers double side
feature
so
the stock does not have to be reloaded and run again?






Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge Word 2003 Issue S.Nicks Mailmerge 5 February 20th 09 02:55 AM
mail merge with attachments AS Mailmerge 5 April 9th 05 09:49 AM
Mail Merge Issue With Office 97 - Excel Data Source Matt Thorley Mailmerge 1 February 16th 05 12:38 AM
Word-Excel 2003 - Mail Merge Recipients problem AYager Mailmerge 2 January 11th 05 05:11 AM
How to get mail merge to use double quotes huntbch81 Mailmerge 0 December 23rd 04 11:23 PM


All times are GMT +1. The time now is 03:56 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"