• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 249
  • Last Modified:

create an email to be sent to multiple people from a list in excel


I am currently trying to create an email that will be sent to multiple people based on data in an excel sheet. I am well aware of mail merge, but to my knowledge, it will only send out 1 email to 1 person. I want to be able to populate the To: field with multiple email addresses based on values in the excel sheet.

for example, if in excel the columns have


then in the to: field, i'll want the email to be sent to abc@email.com; def@email.com

I was hoping to make this is VB so that I can include it in some excel macros that sort the data.

is this possible?
1 Solution
Premkumar YogeswaranCommented:

Check this link below..!


jtovar3Author Commented:
almost perfect, but I just have a few questions on how to format some parts of the email.

1. How can I skip the first row? This should be pretty basic, but I can't quite seem to get it right.

With olMailItm
       SDest = ""
       For iCounter = 1 To WorksheetFunction.CountA(Columns(1))
           If SDest = "" Then
               SDest = Cells(iCounter, 1).Value
               SDest = SDest & ";" & Cells(iCounter, 1).Value
           End If
       Next iCounter

Open in new window

Then I'm try to figure out whether it would be easier to somehow use a template email (although I have no idea how I'd incorporate the code into it, or to do all the formatting myself through VB Code.
Guy Hengel [angelIII / a3]Billing EngineerCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now