ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Paste excel range into a mail item's body (https://www.excelbanter.com/excel-programming/351991-paste-excel-range-into-mail-items-body.html)

Tim[_44_]

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?



All times are GMT +1. The time now is 09:51 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com