I have difficulties in writing a VBA code that allow the mail merge to cc people that I would like to loop in. I’ve checked this one (https://www.msofficeforums.com/mail-...ilmerge-3.html) but have no idea which rows to delete as I do no need to send it out with attachment. My situation is:
- To e-mail in cell A1 and copy people in A2, A3... if it’s not blank
and so on......

Currently I’ve applied a code that allows me to adapt dynamic subject line...