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

,create a macro to send personalized email from excel,send an email from a excel spreadseet list,send email from macro excel cc,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,formula for multiple sending email in excel,personalized mail macro,send mail from excel,send multiple personalized emails,cc several addresses excel,email multiple rows excel macro,email send from excel list,excel email multiple,excel email personalized names,excel list email addresses macro send mail,excel macro email outlook body conditional,excel macro multiple emails,excel macro personalize email,excel macro vba creat email multiple cc,excel multiple email seperate rowa,excel multiple emails,excel vba sending email,how to automatically send email based on values in excel,how to copy multiple email address from excel,how to email a list out of excel,how to personalize in excel multiple names,how to send multiple emails,i have a macro for sending email based on a column how to send in cc,macro codes send email based on cell in spreadsheet,macro to send personalized email from excel,personalize multiple email,personalized email excel vba,personalized email using excel,personalized mail outlook macro,send email automatically to multiple recipients excel vba,send email multiple addresses excel,send email to multiple email addresses from excel in outlook,send mail excel vba multiple recipients,send mail from excel macro,send multiple email excel,send multiple emails personalized,send multiple mail from excel,send multiple mail from excel vba,send multiple mails from excel,send multiple personalized email,send personalized email using excel outlook,sending multiple personalized emails



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