Hello Experts, help please !!
I'd like some help with some vba automation to be triggered from receiving an email. I receive a weekly email and in the body of the email is a link to a spreadsheet.
Ideally I'd like to automate the following:
# Where the email is from "John" and the subject is "Weekly Extract" then open the spreadsheet from the link within the email body
# Save as "Weekly data.xlsx" into our default directory "C:\Project Docs\"
# Then some how run a vba procedure or macro from an access database "Dashboard.mdb" in the "C:\Project Docs\" directory.
Is this even possible ? If so, any help and suggestions will be greatly appreciated