![]() |
#1
|
|||
|
|||
![]()
I have cracked removing blank rows and creating PDF's but cannot get both processes to run at once - I can have PDF's or rows removed not both.
Anyone any advice? I just need to find a way to get the Macro to do both! |
#2
|
||||
|
||||
![]()
Since you haven't posted whatever code you're working with, it's impossible for anyone to provide meaningful advice about that.
That said, see: • Split Merged Output to Separate Documents and, better still, Send Mailmerge Output to Individual Files in the Mailmerge Tips & Tricks 'Sticky' thread at the top of this forum - https://www.msofficeforums.com/mail-...s-tricks.html; and • https://www.msofficeforums.com/137121-post2.html & https://www.msofficeforums.com/129119-post4.html. The For each Tbl loop in either post could simply be inserted before the 'Save As' line in either of the macros referred to above.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
![]()
Sorry, I should be clear I've been in both those threads and managed to do that. Also been on another thread and managed to collect a code which removes rows if blank when looking at a particular column of cells.
The bit I'm struggling with or if it even possible is if I can combine those macros so it removes the rows as it creates individual documents. |
#4
|
||||
|
||||
![]()
Did you read the last sentence in my previous reply?
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
dita | Word VBA | 3 | 10-31-2019 11:09 PM |
![]() |
Btop | Word VBA | 26 | 03-07-2018 01:45 PM |
remove rows without certain word | ewso | Word VBA | 4 | 05-28-2017 01:27 AM |
![]() |
gbaker | Excel Programming | 18 | 07-21-2014 04:51 AM |
![]() |
Learner7 | Excel | 1 | 04-19-2011 02:45 AM |