3 replies to this topic

[bluesea]

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.

[bluesea]

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

[Doug]

Thank you for the update on your progress, bluesea.

Best Regards

[getmoremore]

i have never mail merge before, i am using a third party software to merge documents c# together. so when i am operating word 2003 documents. i have merged documents easily. in your case you need some editing word document tool to delete the blank page.