Send emails

  • good afternoon,

    I would like you to help me build a loop in VBA. I have the body of an email in cell A1, the subject in cell B1, and I want to send it to the emails in column C. I have a macro that sends me the email called "Sendmail", but I want another one that go through column C and in each value of the cell I execute "Sendmail". I thought I could make the macro loop through column C, and have the value of each cell (C1, C2, C3, ...) copy it to another cell, for example D1 and run the "Sendmail" macro for me. So I can indicate in the "Sendmail" macro that the recipient is D1.

    Thanks, I hope your help

  • Here you go. Give this a try: