Sending Multiple Personalized Email from Excel

October 6, 2009 by vba excel
Filed under: Excel Tips 
Sponsor

Excel Tips Sending Multiple Personalized Email from Excel [Q]

I want to send personalized email from excel, i have a column named e-mails in excel that e-mail addresses accommodate in that column. What I want to do is to send an email to selected email addresses via outlook. I want outlook to be opened and all the selected email addresses are placed in the to: field in outlook. Is there any way to do that?

Excel Tips Sending Multiple Personalized Email from Excel [A]

This excel macro can help you send personalized email from excel

Sub Mail_small_Text_Outlook()
Dim OutApp As Object
Dim OutMail As Object
Dim strbody As String
Dim cell As Range
Dim strto As String

Set OutApp = CreateObject(”Outlook.Application”)
Set OutMail = OutApp.CreateItem(0)
strbody = “Hi there” & vbNewLine & vbNewLine & _
“This is line 1″ & vbNewLine & _
“This is line 2″ & vbNewLine & _
“This is line 3″ & vbNewLine & _
“This is line 4″

For Each cell In Selection
If cell.Value Like “*@*” Then
strto = strto & cell.Value & “;”
End If
Next
If Len(strto) > 0 Then strto = Left(strto, Len(strto) - 1)

With OutMail
.To = strto
.CC = “”
.BCC = “”
.Subject = “This is the Subject line”
.Body = strbody
.display
End With

Set OutMail = Nothing
Set OutApp = Nothing
End Sub

  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Google
  • E-mail this story to a friend!
  • Live
  • MisterWong
  • Propeller
  • StumbleUpon
  • Technorati
  • TwitThis
  • YahooMyWeb
  • Print this article!

Rate This Tips:

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading ... Loading ...


Incoming excel search terms

mss,,create a macro to send personalized email from excel,create multiple email adress sending list :excel,personalized email from excel,email files from excel through outlook with cc macro,vba send multiple emails,send an email from a excel spreadseet list,send email from macro excel cc,send mail from excel,send multiple personalized emails,adding multiple cells from excel to outlook,copy cells from excel to email,creating hyperlinks for multiple emails in excel,excel formulas for multiple sending emails,excel personalized email macro,formula for multiple sending email in excel,how to send personalize email to multiple accounts,macro to send personalized email from excel,outlook macro to send personalized email from excel,personalized mail macro,send multiple emails from excel,send multiple emails personalized,sending multiple emails from excel,sending multiple personalized emails,vba email multiple cc,0h,automatically send email excel,cc several addresses excel,create personalized emails from excel,email excel macro,email from excel,email hyperlink to and cc excel,email multiple rows excel macro,email send from excel list,emailing from excel,excel email multiple,excel email personalized names,excel list email addresses macro send mail,excel macro email multiple recipients,excel macro email outlook body conditional,excel macro multiple emails,excel macro personalize email,excel macro to send email,excel macro vba creat email multiple cc,excel multiple email seperate rowa,excel multiple emails,excel send email,excel send email cell value string,excel vba sending email



Related Excel Tips

Tags: , , , , ,

Comments

3 Comments on Sending Multiple Personalized Email from Excel

  1. JP on Tue, 6th Oct 2009 3:14 pm

    2. You might want to wrap your CreateObject call in an error handling statement, otherwise your code might fail with an error. Even better, include it in a separate function that creates the Outlook.Application object.

    E-mail addresses can be separated with a comma if you have the “Allow comma as address separator” option selected in Outlook.

  2. Udyad on Thu, 15th Oct 2009 2:47 am

    3. Sir I have a question, Is it possible that automatic hyperlink is possible. If Yes, then how ? I have a worksheet on which I am entering data in the columns ( bran,date,empcode and view) . Now, My supporting files are stored on a folder having named as bran-date-empcode.pdf (ex. 1188-22072009-25096.pdf) where bran stands for branch code and empcode stands for employee code. I just want to make a sheet that if bran,date and empcode shall be entered on view column cell, view will be underlined and by clicking the same it will automatically hyperlinked to that perticular file.

    Waiting for your response….

  3. srikanth on Wed, 4th Nov 2009 12:52 pm

    4. If i have four cells in 1,2,3, cells there is a data i need to capture the data of 1,2,3 and send to the email linked to cell in 4 column.
    Is that posible

Have another excel answer or questions for this problem ?
Feel free to post it here..