NewOrderFac33
Well-known Member
- Joined
- Sep 26, 2011
- Messages
- 1,275
- Office Version
- 2016
- 2010
- Platform
- Windows
Good morning,
I have been using Ron De Bruin's email generating code for a while now:
but would like to know if there is any way in which I can embed a named worksheet chart (not a chart tab) into the body of the email before it is previewed or sent?
Thanks in advance for your help.
Pete
I have been using Ron De Bruin's email generating code for a while now:
Code:
Dim OutApp As Object
Dim OutMail As Object
Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(0)
With OutMail
.To = EmailAddress
.CC = ""
.BCC = ""
.Subject = "JIRA Releases in Released to UAT status"
.HTMLBody = MsgBody
'.attachments.Add "C:\Pete's Stuff\Sample Attachment.xlsx"
.Display
'.Send
End With
Set OutMail = Nothing
Set OutApp = Nothing
but would like to know if there is any way in which I can embed a named worksheet chart (not a chart tab) into the body of the email before it is previewed or sent?
Thanks in advance for your help.
Pete