
Announcements
Hi Experts,
I need your suggestions regarding mail merge automation. I am trying to do a mail merge from an excel file sample shown below. I have name, email address, fees, ad Year. I want to set a condition if any fees or year column values are blank, I can customise the email using dynamic content.
| Name | email address | Fees | Year |
| A | A@gmail.com | $6 | |
| B | B@outlook.com | 2009 | |
| C | C@outlook.com | $5 | 2008 |
First, you must read the excel, and then through a loop, you can see if those columns are empty, then proceeding with the dynamic mail. please refer to the solution here.