If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Printing MailMerge from both start and end of table in Excel Database
I am using MS Word 2000. I am printing on a HP 8100 duplex printer. I have
an 8 page letter I am printing and merging the address into it. I am printing on both sides of the 11 x 17 paper a total of 8 pages so when you fold it it makes a booklet. The collate is checked in the print dialog box. 1. The 1st problem is that when printed, the first merged address is from the beginning of the database and the next one is from the end of the database. From there it alternates beginning and end. 2. The 2nd problem is when it prints from the beginning of the database the pages face down and then when it prints from the end of the database they are facing up. I am printing 600 copies and doing a bulk mailing so I have to hand sort the zip codes. it is a pain. HELP? |
#2
|
|||
|
|||
Printing MailMerge from both start and end of table in Excel Database
See the article “Duplex Merge Data for Postcards” on fellow MVP Graham Mayor’s
website at: http://www.gmayor.com/duplex_merge_data.htm The other thing that you may want to do is execute the merge to a new document and then send each "booklet" to the printer as a separate print job by using a macro containing the following code Dim i As Long With ActiveDocument For i = 1 To .Sections.Count .PrintOut Range:=wdPrintFromTo, From:="s" & i, To:="s" & i Next i End With -- 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, originally posted via msnews.microsoft.com "cmfd70" u59260@uwe wrote in message news:a64d1e6e9a43a@uwe... I am using MS Word 2000. I am printing on a HP 8100 duplex printer. I have an 8 page letter I am printing and merging the address into it. I am printing on both sides of the 11 x 17 paper a total of 8 pages so when you fold it it makes a booklet. The collate is checked in the print dialog box. 1. The 1st problem is that when printed, the first merged address is from the beginning of the database and the next one is from the end of the database. From there it alternates beginning and end. 2. The 2nd problem is when it prints from the beginning of the database the pages face down and then when it prints from the end of the database they are facing up. I am printing 600 copies and doing a bulk mailing so I have to hand sort the zip codes. it is a pain. HELP? |
Thread Tools | |
Display Modes | |
|
|