------ Register to get rid of these "In Post" ads! ------


I need some assistance creating a VBA macro for an email that I send out frequently to different recipients, but always the same subject/body. Below is what I have but cannot seem to get the body of the email in there w/o receiving an error.

Sub NewMail()
Dim objOLApp As Outlook.Application
Dim NewMail As Outlook.MailItem
Set objOLApp = New Outlook.Application
Set NewMail = objOLApp.CreateItem(olMailItem)
NewMail.SentOnBehalfOfName = "email@domain.com"
NewMail.Display
End Sub

------ Register to get rid of these "In Post" ads! ------


It's well documented here Using Automation to Send a Microsoft Outlook Message

__________________
Regards,
Simon Lloyd
Excel Chat

------ Register to get rid of these "In Post" ads! ------


hi Mikera,

Welcome to the Forum

Here is a page of links on Ron Debruin's site that may have some different examples to Simon's MS link.

Edit: Ooopps! here's the link: Example Code for sending mail from Excel

hth
Rob

__________________
Rob Brockett. Always learning & the best way to learn is to experience...