Reformat mail merge for double sided printing
Say, 2 easily do double sided printing I need to reformat the attached. A5 cards are required but A4 card is to be used. The Mail Merge document needs to be setup to print 2 cards per A4 page - the 1st records and 2nd record one beneath the other (so that it can be sliced in half) and the second page (no merge fields in this page) similarly on the 2nd page. Please feel free to cut and paste and reformat as needed. Tx
SOSA-Gift-Card---Pesach-5776---2016.docx
SOSA-Gift-Card---Pesach-5776---2016.docx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Tx Rob. Sorry, I don't follow this exactly - can you please illustrate with the attached file please.
What do you mean by 2 sided printed - duplex printing or just where it prints one page 1st and then one puts paper in a 2nd time?
What do you mean by 2 sided printed - duplex printing or just where it prints one page 1st and then one puts paper in a 2nd time?
If your printer can handle duplex printing then I was referring to that; if not then you are back to doing as suggested by the original comment.
I cannot open your document as it wants to link to the DataSource which I don't have so it won't open in a manner which can be edited.
It looks like you currently have a 2 page document and I assume each page is set to A5 Landscape. You have the personalised section on the first page and the sponsorship details on the second page.
Create a document with 2 A4 Portrait pages and divide each page into two panels, top and bottom, by inserting a table that is 1 column wide and 4 rows high. Size each panel so that they fill half of each page.
On the first page recreate the personalised section in both panels. You can split each panel into further cells if so required to achieve the layout.
Assuming you are using Word Mail Merge, the first entry on the second panel will be the <<Next Record>> statement.
On the second page recreate the sponsorship details twice, filling both of the panels.
When this now prints on a duplex printer, two personalised sections will print on one side of the page and the sponsorship details will print twice on the reverse. Each page can then be sliced in two.
Thanks
Rob H
I cannot open your document as it wants to link to the DataSource which I don't have so it won't open in a manner which can be edited.
It looks like you currently have a 2 page document and I assume each page is set to A5 Landscape. You have the personalised section on the first page and the sponsorship details on the second page.
Create a document with 2 A4 Portrait pages and divide each page into two panels, top and bottom, by inserting a table that is 1 column wide and 4 rows high. Size each panel so that they fill half of each page.
On the first page recreate the personalised section in both panels. You can split each panel into further cells if so required to achieve the layout.
Assuming you are using Word Mail Merge, the first entry on the second panel will be the <<Next Record>> statement.
On the second page recreate the sponsorship details twice, filling both of the panels.
When this now prints on a duplex printer, two personalised sections will print on one side of the page and the sponsorship details will print twice on the reverse. Each page can then be sliced in two.
Thanks
Rob H
If you don't have a duplex printer then create it as two separate documents, rather than two pages.
The merge fields on one document in a table with two panels as described above; the sponsorship details on a second document but still in a table with two panels duplicated.
You can then use the first document as your merge document and you will get your prints on one side of the document. Then put the card back into the printer ensuring it is right way up and right way round, depending on printer model, and print the second document so that it goes on the reverse of the already printed sheets. It might be worth some trial and error testing rotation of the paper for the second print before doing it for real.
Thanks
Rob H
The merge fields on one document in a table with two panels as described above; the sponsorship details on a second document but still in a table with two panels duplicated.
You can then use the first document as your merge document and you will get your prints on one side of the document. Then put the card back into the printer ensuring it is right way up and right way round, depending on printer model, and print the second document so that it goes on the reverse of the already printed sheets. It might be worth some trial and error testing rotation of the paper for the second print before doing it for real.
Thanks
Rob H
ASKER
Hi Rob, This is basically what Helen_Feddema suggested.
Putting paper in again can cause paper jams as ink can stick.
Do you know if one can do this easier with an Access Report instead?
Putting paper in again can cause paper jams as ink can stick.
Do you know if one can do this easier with an Access Report instead?
Unless you have a duplex printer, then you will have to do that. I notice one of your sponsors is a printing company; I would surprised if they can't do duplex. Would be worth asking.
Whichever, you still need the layout of the document as A4 portrait with duplicate images top and bottom so that it can be cut into two A5 landscape pieces.
Whether you use Word or Access will still be constrained by the printer.
I agree that double feeding the paper can be problematic; its OK for a few pages but I guess you are printing lots.
Whichever, you still need the layout of the document as A4 portrait with duplicate images top and bottom so that it can be cut into two A5 landscape pieces.
Whether you use Word or Access will still be constrained by the printer.
I agree that double feeding the paper can be problematic; its OK for a few pages but I guess you are printing lots.
Set the first page with a table arrangement as per a normal Mail Merge document, second table with the <<Next Record>> in the first cell as usual.
Then on your second page put the required printing for the second page.
Then set the printing to two sided.
In theory, the printing on the second page is printing as part of the second and subsequent record print but if it is on the reverse of the page, who is to know??