![]() |
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