View Single Post
 
Old 12-17-2010, 06:10 PM
blusea blusea is offline Windows XP Office 2003
Novice
 
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