Hi guys
The following code sends an attachment with the email to different recipients. Is it possible instead of attaching the sheet with the email, Just include it in the body part of the email. I mean where we write other text like "Hello How r u? " and then the data of sheet11 will come after it.
Please Login or Register to view this content.
Last edited by Nancy123; 09-30-2010 at 07:06 AM.
see: http://www.rondebruin.nl/sendmail.htm
specifically the section Outlook object model (body)
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
I tried the link but it was again sending the sheet as an attachment with the email. Can anyone please send me the code for this .
Thanks a lot.
The link was to a list of other pages. The one you want to try is here:
http://www.rondebruin.nl/mail/folder3/mail4.htm
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Hi It is working if there is only one recipient but if there are multiple recipients then instead of including the names in Cc or Bcc, how can we include the all names in To section.
Thanks so much.
Hi All...Can anyone please figure out my problem?
Thanks guys... My problem has been resolved...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks