Solved

Word Mail Merge - Need Help!

Posted on 2004-10-06
5
468 Views
Last Modified: 2010-08-05
Hello -

I have a Word mail merge that gets data from an Access database.  When the records are merged, some records will generate 3 section pages, some section 4 pages, etc.  What I need is to add a blank page to the records that generate "Odd" section page counts.  The merged document gets duplexed (via a printer with duplexing capabilities).  I need to make sure that a page from one record does not duplex on to the back of other records when it prints.  Can this be done?  

Thanks.
0
Comment
Question by:amrnorman
  • 2
  • 2
5 Comments
 
LVL 7

Expert Comment

by:J_Mak
ID: 12245749
Why can't you just set the printer not to print back to back?

Assuming you have Windows XP, you can go to Control Panel, select "Printers and Other Hardware". Then select "Printers and Faxes". Right-click on the printer you want to print to and select 'Properties' from the contet menu that is displayed after right-clicking. You should have the option of setting either double or single sided printing. If you want to do this in word, you would also have to choose "Print..." from the file menu. Choose "Options..." in the dialog box which appears, then depending how your Word is setup, you will have to look somewhere to set something so that only single -sided printing will be performed. Hope that helps.

0
 

Author Comment

by:amrnorman
ID: 12245786
I am working with Windows 2000.  Upon the merge, I could have a total of 156 pages, based on say, 35 records.  These pages are consecutive.  Duplex printing is automatic.  My problem is that some records generate three pages, others generate two.  I need the total page count for each record to have even pages.  Otherwise, I end up with page three of record one printing on the back of record two.
0
 
LVL 7

Expert Comment

by:J_Mak
ID: 12245901
Does Windows 2000 have the option of opening the Properties dialog of each printer available on the network? If so, then try doing it that way. I'm sure there is a way to print single pages. You said you wanted to insert blank pages in between so it's just the same as printing single sided, correct?
0
 

Author Comment

by:amrnorman
ID: 12245932
Hi.  I do not want to print single sided.  These are letters that I need to have duplexed.  I am trying not too kill too many trees. If I have record that has three 'single' pages with text on them, I want two singles to be duplexed on one piece of paper and the the third single page to be duplexed on a second piece of paper with a blank single on the other side.  I have tried working with section page parameters within Word, but have not had any luck.

Thanks.
0
 
LVL 5

Accepted Solution

by:
Miles_stylus earned 500 total points
ID: 12246889
Use section breaks - Insert/Break/chose either odd or even.  This will then force the following section to be displayed on the next odd or even page.  Notice that this will only be apparent when you look on File/Print Preview.

This I would suggest that you have an odd or even section break at the end of the mail merge record.

HTH

Miles
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

If you work with Word a lot, you probably use styles. If you use styles a lot, you've probably balled your fist more often than not when working with the ribbon. In Word 2007/2010, one of the things that I find missing when using styles is a quic…
Preface: When I started this series, I used the term CommandBars because that is the Office Object class that it discusses. Unfortunately, when Microsoft introduced Office 2007, they replaced the standard Commandbar menus with "The Ribbon" and rem…
In this video, we show how to convert an image-only PDF file into a PDF Searchable Image file, that is, a file with both the image (typically from scanning) and text, which is created in an automated fashion with Optical Character Recognition (OCR) …
This video walks the viewer through the process of creating a watermark for their document, customizing it, and saving it for viewing/printing needs.

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now