Hi
Is there a way to input a button on excel and to let it know once i press it to attach the current excel worksheet and open outlook with the subject and content of the email entered.
Hi
Is there a way to input a button on excel and to let it know once i press it to attach the current excel worksheet and open outlook with the subject and content of the email entered.
What's wrong with the attach to E-mail option that already exists in Excel?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Hi Ali,
I would like to place this as a add on function on the report it self. So that users with a click of a button, can auto open to outlook and have the report attached to be send. As the recipient and the content of the message will always be the same, It would be more faster. I guess just like the quick steps function in outlook.
link this code to button and play around with it...with a click of a button can auto open to outlook and have the report attached to be send
Please Login or Register to view this content.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
Hi There. I have placed the code as given and had an error copile error message when I run the macros.
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Hi there. The code worked toan extent. I did receive an message that said the VB can't be used in a macro free workbook. This happened because the code opened report into a new worksheet. Should i edit the code to WhateverName.xlsm to not not prompt this dialog box? the second thing is that I noticed the new workbook that opened only had one worksheet which had the button. The rest of the worksheet in this file was not placed in the attachment.
Change 51 to 52.
The code works on the active sheet when running so if your sheet has no data you copy an empty sheet.attach the current excel worksheet
Sorry...was out...I see bakerman2 solved...Tx for rep+
Hi Guys,
If i need the code to attach the whole workbook instead of sheet, how do i amend
Please Login or Register to view this content.
Thanks Bakerman2
You're welcome and thanks for rep+.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks