#1
|
|||
|
|||
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. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mail Merge to create specific number of table rows | flackend | Mail Merge | 4 | 12-01-2023 02:49 PM |
Mail merge with multiple rows of data | ARoude | Mail Merge | 3 | 09-10-2018 02:32 PM |
Deleting rows based on the text in certain cells VBA | ThisGuyJohn | Excel Programming | 5 | 02-03-2017 03:16 PM |
Excel VBA Macro - Deleting Specific Data based on criteria | MD011 | Excel Programming | 3 | 12-10-2014 02:15 AM |
Mail Merge to print specific record based on mergefield criterias | nicnad | Mail Merge | 1 | 02-22-2012 01:53 AM |