Solved

Word Mail Merge - Need Help!

Posted on 2004-10-06
5
470 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Software to count how many instances of words 109 174
In MS Word, rename styles in a batch 9 44
MS Word document > cursor placement 5 33
vba - Word save error 11 9
Introduction Authors who set out to write any sort of lengthy piece for online submission—be it a long question or comment on a technical form, an article, or a substantial blog entry—often find it useful to work up a draft in an editor other t…
The Selection object is designed for user interaction. It has a Range property, so it can be used in most places that a Range object can. Recorded macros must use the Selection because they are simply copying what the user is doing. A Range prope…
This video shows the viewer how to set up and create Footnotes in their document. Click on the References tab: Select "Insert Footnote": Type in desired text:
The viewer will learn how to make their project stand out over others by learning how to change colors and shapes, add spaces, change directions, and add bullets to their charts.

773 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