Is there a way to execute a mail merge using excel as data source to word but with multiple recipients and changing email subject using macro?

36 views Asked by At

I am no expert in macro excel but I am trying to automatically send email to multiple recipients (TO and CC) included per each cell and just separated by semicolon. Additionally, the email subject is also changing if only possible. I have attached here the sample word and excel as data source. Appreciate any help that you could share with me. Thanks in advance!

enter image description here enter image description here

0

There are 0 answers