View Single Post
 
Old 03-24-2022, 11:17 AM
nsaini01 nsaini01 is offline Windows 10 Office 2019
Novice
 
Join Date: Mar 2022
Posts: 2
nsaini01 is on a distinguished road
Default Remove Blank Rows in Tab to Email Mail Merge

Hi I have multiple letters I need to email to recipients but I am using mail merge in a table format to pull in data from excel. Some letters needs all the line in the table while others only need half or even less. How do I prevent the empty rows to show in the final email, is there a marco or something else that can be used? I have attached table in word and excel where the info is pulled.

Thank you

Last edited by nsaini01; 03-25-2022 at 06:57 AM.
Reply With Quote