Jump to content

Build Theme!
  •  
  • Infected?

WE'RE SURE THAT YOU'LL LOVE US!

Hey there! :wub: Looks like you're enjoying the discussion, but you're not signed up for an account. When you create an account, we remember exactly what you've read, so you always come right back where you left off. You also get notifications, here and via email, whenever new posts are made. You can like posts to share the love. :D Join 92417 other members! Anybody can ask, anybody can answer. Consistently helpful members may be invited to become staff. Here's how it works. Virus cleanup? Start here -> Malware Removal Forum.

Try What the Tech -- It's free!


Photo

delete blank pages from mail merged word 2003 document


  • Please log in to reply
3 replies to this topic

#1 bluesea

bluesea

    New Member

  • New Member
  • Pip
  • 2 posts

Posted 17 December 2010 - 07:24 PM

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.

    Advertisements

Register to Remove


#2 bluesea

bluesea

    New Member

  • New Member
  • Pip
  • 2 posts

Posted 18 December 2010 - 01:21 PM

*******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
**************************

#3 Doug

Doug

    Retired Administrator -Tech Team

  • Tech Team
  • 10,057 posts

Posted 26 December 2010 - 12:42 AM

Thank you for the update on your progress, bluesea.

Best Regards
The help you receive here is free.
If you wish, you may Donate to help keep us online.

#4 getmoremore

getmoremore

    New Member

  • New Member
  • Pip
  • 1 posts

Posted 25 August 2013 - 09:36 PM

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.

Related Topics



0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users