I need some with VBA code. Im a newbie on VBA and Im stuck on something.
I want to build a code that will allow excel to copy the active worksheet within an range and save it as an .xslx and PDF file (yes both documents) and attach it to a email. I found a number of forms that that either or the other but not both. I know it needs to keep the information in a temp file and have it deleted after.
This is iceing on the cake. Is there is also a way to select a few cells and copy that and paste into the body on the same email?
any help will be truly appreciated.
Thanks!!
Bookmarks