Let's say I have a workbook open. After working on it and saving it, I need to email it as an attachment, to an email address in cell B20.If I can achieve both the above, it will be a great help to the project that I am currently working on.
- What VBA code would I use, without the macro prompting me to enter the file name?
- And can I email an open Excel file as an attachment in the first place?
I have read the code in this post with interest, and if it can be modified to fulfill my requirements, it will be great.
Thanks in advance.
Bookmarks