View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tim[_44_] Tim[_44_] is offline
external usenet poster
 
Posts: 28
Default 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?