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.
|