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

Posted on 2011-04-27
Last Modified: 2012-05-11

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;

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?
Question by:jtovar3
    LVL 17

    Accepted Solution


    Check this link below..!


    Author Comment

    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.
    LVL 142

    Expert Comment

    by:Guy Hengel [angelIII / a3]
    This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    Office 365 Sync with office 2016 3 19
    exchange 2007 2 23
    Word 2016 stuck on "starting" splash screen 10 27
    Excel list clean up 6 22
    Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
    Use email signature images to promote corporate certifications and industry awards.
    The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now