Macro to send email to multiple recipients separately where the subject line is the corresponding topic for that email address.

  • I have a pivot table that includes email addresses and topics corresponding to each email address. I need to create a macro that will send an individual email to each email address and use the corresponding topic as the subject line. For example,


    Email Topic

    [email protected] Auto Insurance

    [email protected] Professional license


    I would expect to send and email to [email protected] with a subject line of auto insurance and so on down the list. I have this working with the exception that it is duplicating each email. I think this is due to my range being read through twice but I am unsure how to fix it. Please advise on how to stop the duplicate emails



  • Try:

    You can say "THANK YOU" for help received by clicking the :thumbup: icon in the bottom right corner of the helper's post.
    Practice makes perfect. I am very far from perfect so I'm still practising.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!