We help IT Professionals succeed at work.

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

jtovar3
jtovar3 asked
on
Medium Priority
260 Views
Last Modified: 2012-05-11
Hello,

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

abc@email.com
def@email.com

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?
Comment
Watch Question

Sr. Analyst - System Administrator
CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

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
           Else
               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 Engineer
CERTIFIED EXPERT
Most Valuable Expert 2014
Top Expert 2009

Commented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.