Sending e-mails from excel database.

  • Thread starter Thread starter msnews.microsoft.com
  • Start date Start date
M

msnews.microsoft.com

Is it possible to send a "form" email to all contacts from an excel
database?

Answer soon if you could to (e-mail address removed). Thank you!

Marcia
 
I really don't want to send the sheet Ron. What I am looking to do is use
the e-mails in the excel database as a distribution list of sorts w/o having
to re-enter them. I would like to send one email to all the names listed in
the database (approxiamately 20-30).

Is that possible?
 
Hi

See the tips for changing the To and Body

http://www.rondebruin.nl/sendmail.htm#Outlook

Sub Mail_Outlook()
'You must add a reference to the Microsoft outlook Library
Dim OutApp As Outlook.Application
Dim OutMail As Outlook.MailItem
Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(olMailItem)
With OutMail
.To = "(e-mail address removed)"
.CC = ""
.BCC = ""
.Subject = "This is the Subject line"
.Body = "Hi there"
.Display ' or .Send
End With
Set OutMail = Nothing
Set OutApp = Nothing
End Sub
 
Back
Top