| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Mailing an excel range in the body of an e-mail | Excel Discussion (Misc queries) | |||
| sending mails from excel...but mail body disappearing | Excel Discussion (Misc queries) | |||
| Paste range of cells on E-maul Msg Body | Excel Programming | |||
| Copy and Paste a Worksheet Range to Email Body | Excel Programming | |||
| Sending Mail from Excel: Body Text | Excel Programming | |||
![Tim[_44_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
