i have assigned code to send mail through excel in outlook but
but i want assign the body text as sheet range(A3:I10) of pivot this range map to bodytext of every mail from every workbooks.
i have enclosed two files one is mailsender and another sheet which to attach and send contains PIVOT sheet in first tab.
Hi,
you need to use the RangetoHtml function from RonDeBruin to paste the required range into the msg body.
http://www.rondebruin.nl/win/s1/outlook/bmail6.htm
The Aegis Inforware book needs to be opened to copy the range.
....I forgot you'll need to add code to close the opened file once the mail has been sent!!
You may have to modify the code but hopefully you'll get the gist.
Please Login or Register to view this content.
Last edited by daverunt; 06-07-2013 at 12:42 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks