 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / January 2006ActiveWorkbook.SendMail - Message body
Sub SendActiveWorkbook() ActiveWorkbook.SendMail _ Recipients:="person@gmail.com", _ Subject:="Test" & Format(Date, "dd/mmm/yy") End Sub How can I add a message body to the above mail?? Hello Al007, The SendMail method has no option for "Body" because the Workbook is considered to be the body of the email. To have a body to the email you would need to send the workbook as an attached file through another program like Outlook. Sincerely, Leith Ross  SignatureLeith Ross Like Leith told you this is not possible with SendMail But if you onlu use Outlook Express and not Outlook look at CDO http://www.rondebruin.nl/cdo.htm SignatureRegards Ron de Bruin http://www.rondebruin.nl > Hello Al007, > [quoted text clipped - 5 lines] > Sincerely, > Leith Ross |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.