asked on Excel VBA Email Envelope Embed two ranges in the body
Hi
I use the following code to build an email in the Mail Envelope
I want to embed two small ranges in the body. How do I do this?
With Globals.ThisAddIn.Applicat
.Visible = True
.Item.To = oDetail
.Item.Cc = oDetail2
.Item.Subject = oDetail3
.Item.Body = oDetail4
.Attachment = oDetail5
'.Item.Send()
End With
I use the following code to build an email in the Mail Envelope
I want to embed two small ranges in the body. How do I do this?
With Globals.ThisAddIn.Applicat
.Visible = True
.Item.To = oDetail
.Item.Cc = oDetail2
.Item.Subject = oDetail3
.Item.Body = oDetail4
.Attachment = oDetail5
'.Item.Send()
End With
Microsoft ExcelVBA
Last Comment
Murray Brown
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
but of course you answered my question. Thanks very much
I got the error
Public member 'Attachment' on type 'IMsoEnvelopeVB' not found.