[bluesea2]

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.

*******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....=1631821&page=1
**************************

Edited by bluesea2, 18 December 2010 - 01:19 PM.