Paste excel range into a mail item's body
I can copy and paste one range to another and I can copy a selection to
the clipboard, but I can't figure out how to paste the selection into a
mail item's body. For instance ...
Cells.Copy
Set SendMail = Outlook.CreateItem(olMailItem)
With SendMail
.Display
.Subject = [A1].Value
.To = ""
.Body = ""
End With
But how do I paste the cells copy on the clipboard to the body?
|