Hello guys,
I have done only a couple of really simple macros so far and I would need your help on that one!
Scenario: I want an excel sheet (not the workbook) to be sent automatically to a specific email address via Outlook, WITHOUT having to click on "Send" in the outlook interface.
Now, I found this code on ron de bruin website, which worked but I had to click on "send" once the sheet was attached to the email:
http://www.rondebruin.nl/win/s1/outlook/amail2.htm
Is there any code to add so that I do not need to click on "send" in outlook, and the email would be sent automatically with the sheet attached?
Any thought is a great help!
Thank you guys
Bookmarks