PDA

View Full Version : Help with an automated e-mail macro



bakerjase
11-16-2011, 02:16 PM
I am trying to come up with a macro that will select the last modified file folder (or the one with the latest date entry), select the file contained within (it will always be named IMG.pdf), attach it to an e-mail and send it. I'm sure the recorded macro will work for the last bit but I have no clue how to tell vba to look for the file.

Any help would be greatly appriciated.

JP2112
11-22-2011, 12:39 PM
What is the scope of "the last modified file folder" -- every folder on your hard drive? Every folder on a network drive? Something else?