I need to a send a bunch on emails from Outlook that reads from Word and Excel. The text content will be from Word and user_email_ID, First_Name content will be from Excel. I know how to do up to this part and have done so in the past but a new addition will be to merge some fields only based on yes/no (
N) from the Excel sheet. For example:
Name Age Field1 Field2 Field3 XXX 39 Y N Y YYY 29 N N N ZZZ 10 Y Y Y
In the above case, the text should look like:
for Record 1
Hello <Name> text text text, items 1) Field 1 2) Field 3
for Record 2
Hello <Name> text text text, items No Items, you are good to go.
for Record 3
Hello <Name> text text text, items 1) Field 1 2) Field 2 3) Field 3
This part should not take me much time to do in C++, or even is MySQL but I am not so quick using Microsoft products like Excel, Word, Outlook.
Can someone be kind enough to give me a heads up on which one should I start looking for in Outlook or Excel, or redirection to a relevant article please? Also, has anyone had the same problem before?