Hi all! Hope you're doing well. I'm trying to automate a report for a coworker.
I have all the data manipulation, formatting and email build with the To, CC, Subject and Body but attaching the file is giving me fits! Works perfectly if the path is on my computer but this file's natural location is a network drive but my code fails if the alias or the fully qualified path is used. Wasn't sure if I could use the TempWorkbook or fix the problem going out to the network drive. Attached is what I've got cooked up so far. Any help is greatly appreciated! =)
* Note ignore the comment on the add attachment line. it doesn't work when the comment is removed, just missed it when i was taking all the company info out of it
Bookmarks