Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

delete blank pages from mail merged word 2003 document


  • Please log in to reply

#1
bluesea2

bluesea2

    New Member

  • Member
  • Pip
  • 1 posts
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.

  • 0

Advertisements







Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP