Solved

Word Mail Merge - Need Help!

Posted on 2004-10-06
5
476 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Do you ever need to create a 20 page Word document for some testing purpose? Are you tired of copying & pasting old boring "lorem ipsum" text over and over again, increasing font size and line space in order to make the document 20+ pages long? Look…
When creating Microsoft Word-based forms there may be a need to have a form field repeated throughout the whole document. For instance, with a company name, you may want this information repeated automatically throughout the document rather than man…
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
In a previous video Micro Tutorial here at Experts Exchange (http://www.experts-exchange.com/videos/1358/How-to-get-a-free-trial-of-Office-365-with-the-Office-2016-desktop-applications.html), I explained how to get a free, one-month trial of Office …

696 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