Mail merge problem

[PCOR]

Hi
A while back I got some real help here...and I am at it again. Here is what
I would like to do:
I am printing receipt for a charitable organization
There will be about 900 receipts to print
I would like to print as follows:
On an 8.5 X 14 sheet, I want to print Receipt No 1 at the top, then a
duplicate of that receipt immedialtely below
In the lower half of the page I want to print receipt No 2 and a duplicate
below that
In other words FOUR receipt(Original No 1 and a duplicate and Original No 2
and duplicate.
Can some please tell me how this can be done
Thanks very much

 

[Doug Robbins - Word MVP]

Hi Ian,

Use a Label type mailmerge with four labels to the sheet and remove the
NextRecord field from second and fourth labels on the sheet. When you then
execute the merge, you will get what you want.

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

 

[PCOR]

Sorry about that I clicked the wrong button
I say again
Could you give me a blow by blow description on how to do this
Thanks And ASgain I am sorry for going direct

Hi Ian,

Use a Label type mailmerge with four labels to the sheet and remove the
NextRecord field from second and fourth labels on the sheet. When you then
execute the merge, you will get what you want.

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

Hi
A while back I got some real help here...and I am at it again. Here is what
I would like to do:
I am printing receipt for a charitable organization
There will be about 900 receipts to print
I would like to print as follows:
On an 8.5 X 14 sheet, I want to print Receipt No 1 at the top, then a
duplicate of that receipt immedialtely below
In the lower half of the page I want to print receipt No 2 and a duplicate
below that
In other words FOUR receipt(Original No 1 and a duplicate and Original

No

 

[Doug Robbins - Word MVP]

Hi Ian,

You did not tell us what version of Word you are using, so these
instructions will be for Word XP/2003.

Also, I am not sure if there is an Avery label that suits, so we'll start
with just a blank page.

1. Insert a 4 row by 1 column table
2. Adjust the height of the rows so that suit the receipts that you want
to create, setting the height to an exact figure.
3. Enter the fixed text that you want in the first cell
4. Display the Mail merge toolbar
5. Click on the Main document setup button and select Labels as the type
of Mail Merge that you want to perform.
6. Click on Cancel in the Labels dialog that appears.
7. Click on the Open Data Source button on the Mailmerge Toolbar and open
the datasource that you want to use to create the receipts.
8. Insert the merge fields containing the data for the receipts in the
first row/cell of the table
9. Click on the Propogate labels button on the Mail merge tool bar
10. The contents of the first cell will then be replicated in the other
three cells in the table with a << Next Record>> field beings inserted as
the first item in the second through the fourth cells of the table.
11. Remove the <<Next Record>> field from the beginning of the second and
the fourth cells of the table
12. Execute the merge either to the printer or to a new document.

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

Sorry about that I clicked the wrong button
I say again
Could you give me a blow by blow description on how to do this
Thanks And ASgain I am sorry for going direct

 

[PCOR]

Hi
I am using version 2002 but all you said worked VERY well
Many thanks
Ian

 

[Malcolm]

While Doug has sent you a technical solution you might
find it as easy to print you batch in duplicate. ie run a
second copy. Or even simply make a photocopy. I presume
that the second copy is for file purposes. It would be
easier to keep a single page with 4 receipts than the 4
separate receipts. (Just a thought)

 

[PCOR]

Thanks BUT
The idea is to send out TWO copies to the donor. One for tax purposes and
the other for his/her records
Thanks for ther effort