Hi:
I am using the following code currently:
Can I add to this so that the worksheet that saves will attach itself to an email? If it means multiple windows opening up that's fine. Just curious to see how this would work.
Please Login or Register to view this content.
Thanks
You can use the SaveCopyAs method to save a distinct copy of the workbook and then email that.
There are plenty of examples here: http://www.rondebruin.nl/sendmail.htm
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks