Deleting specific rows in Mail Merge document based on data in cells
Hi everyone,
I'm hoping someone can help me with a problem I'm having with a mail merge document. I've created a mail merge document that pulls data from an excel sheet to generate approximately 300 monthly invoices.
What I need help with is writing a macro that after doing the merge it looks at the three highlighted cells (Interest Adjustment/Tax Reserve/Fees) and if they show a balance of $0.00 then the row(s) are deleted.
I'm not very familiar with macros, so I would appreciate any guidance or suggestions on how to achieve this.
Thank you in advance for your help.
|