Deleting specific rows in Mail Merge document based on data in cells

Rundgren · #1 05-03-2024, 02:03 PM

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