![]() ![]() 'This part is setting the strings and objects to be files to grab with their associated filepath. ' This example sends the last saved version of the Activeworkbook object. Then it emails the file to whomever you specify. 'This macro grabs the file path and stores as a concatenation/variable. Here is the code for sending the email: Option Explicit ![]() Sometimes the email gets stuck in the Outbox and does not send until I open up Outlook. I have some macros and Task Scheduler to launch Excel at a specified time, update some tables, create PDF documents from those tables and then email those PDF documents to select individuals. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |