Hey Guys, i have a macro that will auto-populate information in an email when i enter a value into the E column. That works great. I want to take it one step further and make it so once the new email window is opened i want it to automatically open the outlook file attachment window at a given directory. Is this possible?
My directory would be "Z:\Shared\All Jobs\20943 - AH Fish Addition and Renovation\RFIs\2 - RFI Responses"
Here is the code i have so Far:
Here is the Excel File:HTML Code:
https://brasfieldgorrie.egnyte.com/dl/SkrzaT7MNR
I want to manually grab the file so i know im getting the correct one. I just want the file browser to open so that i dont forget to attach the PDF file to the email before i send it.
Thanks!
Bookmarks