I don't. I don't use Outlook.
I'd go to Ron de Bruin's page and look through some of his sample email code.
http://www.rondebruin.nl/sendmail.htm
Nippy wrote:
Thank you, this is now working a treat.
Ideally i would like to start the body of the email with a line from the
workbook such as
Dear "name"
and then finish off with a standard signature from Outlook,
I could add the standard signature into the code but i don't get the nice
html effects i have in my signature
Any suggestions?
"Dave Peterson" wrote:
Select your project in the VBE
tools|References|
look for Microsoft Outlook xx.x Object Library
and check it.
Nippy wrote:
I too would like to get a result from this; however i get a compile error:
user- defined type not defined.
Any suggestions?
"Jim Jackson" wrote:
Modify the Ranges and Values to suit your situation.
Dim OutApp As Outlook.Application
ThisWorkbook.Activate
Dim OutMail As Outlook.MailItem
Dim strbody As String
A = Sheets("Macros").Range("C16").Value
B = Sheets("Macros").Range("C18").Value
C = Sheets("Macros").Range("A1").Value
Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(olMailItem)
strbody = "Attached is the " & C & " CSFB Activity Report." & vbNewLine
& vbNewLine & _
"Please let me know if you have any questions."
Enclosures = wbk1
IncludeAttachments = True
With OutMail
.To = A
.CC = B
.BCC = ""
.Subject = "CSFB Activity Comparison"
.Body = strbody
.Attachments.Add Workbooks(wbk1).FullName
' .Attachments.Add Workbooks(wbk2).FullName
.Display
End With
Set OutMail = Nothing
Set OutApp = Nothing
--
Best wishes,
Jim
"sdvl" wrote:
i'm trying autosend e-mails from excel, but need to every time outoolk opens
already shows subject and message body. The hyperlink function is part of a
formula that provides acees to outlook
--
Dave Peterson
--
Dave Peterson