Making a macro run for each page in a mailmerge
Hello,
Bit of a newb here, so apologies if this is a dumb question.
I've set up a mailmerge, and its all working fine, but part of the document is a table. I've flattened my data, so that I have fields for row1, row2 etc, but what I would like to do is hide the rows in the table if they are not populated.
I've written a macro which removes the borders of each row of the table, if the cells aren't populated, but I'm struggling to make it call. I want it to run after each page of the mailmerge is created but before the document is sent to print.
Googling the problem brings up a lot of people trying to run a mailmerge from a macro, but I can't find many people trying to run a macro from a mailmerge
Is this possible?
|