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