Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-17-2010, 06:10 PM
blusea blusea is offline delete blank pages from mail merge document Windows XP delete blank pages from mail merge document Office 2003
Novice
delete blank pages from mail merge document
 
Join Date: Dec 2010
Posts: 2
blusea is on a distinguished road
Default delete blank pages from mail merge document

Hi,

I have a 20 page document, each page has an identical layout with a mixture of text and tables.

I am running a mailmerge on the document which works successfully. My problem is that after the mail merge has completed, I am left with about 15 blank pages per record as their is not always data to merge for every page for each record. Does that make sense? I am printing the final document when the mail merge completes but I dont want to print lots of "blank" templates where no data was merged for that record.



Does anyone know of a macro I can run on the mail merged document which will delete the pages where no data was merged to it. To decide if a page is deleted, the condition could be something like
if mergefiled = blank or if particular cell in table is blank,
then delete complete page of document

Any advice would be greatly appreciated.

***using word 2003*****

*******EDIT************
I cross posted this message to quite a few groups without realising about cross posting etiquette. Apologies.
Please see the original post at:
http://www.tek-tips.com/viewthread.c...1631821&page=1
**************************

Last edited by blusea; 12-18-2010 at 12:28 PM. Reason: poinin
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatic insertion of blank pages or alternate text Diopippo Word 0 07-06-2010 12:13 AM
Unable to delete the last blank page. anandjeevakan Word 0 12-11-2009 05:20 AM
How do you delete a blank page at end? aerophil Word 4 10-24-2009 05:04 AM
hidden blank pages mljm Word 3 06-19-2009 03:18 AM
"Intentionally left in Blank" Pages Manolo Word 2 04-30-2009 04:20 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:42 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft