View Single Post
 
Old 02-16-2018, 04:33 AM
Btop Btop is offline Windows 10 Office 2016
Novice
 
Join Date: Feb 2018
Posts: 17
Btop is on a distinguished road
Default

Ok so different letters have different number of items, which are listed in a table. Seeing how field codes don't disappear when in tables, I introduced the following functions into the rows in column A:

{ IF { Mergefield Item1 } = "" "$" "{ Mergefield Item1 }" }
{ IF { Mergefield Item2 } = "" "$" "{ Mergefield Item2 }" }
{ IF { Mergefield Item3 } = "" "$" "{ Mergefield Item3 }" }
...

So when there's no ItemX, $ is introduced and then my MACRO 1 deletes all those empty rows. This is working great.

To use this MACRO 1, I need to click on Finish and Merge first to have all the letters show up. Once all the empty spaces are deleted with this MACRO1, I'd need to save the records as individual PDFs.

In essence, the problem is:
MACRO 1 -> Only works after Finish and Merge
MACRO 2 -> Only works before Finish and Merge

Could these macros be tweaked in some way? Any alternative that isn't too time consuming?

Thanks for your time Paul, bare with me, my knowledge on this is limited
Reply With Quote