Trigger Excel Macro From Outlook Email (from a specific Thread/Person)

[carlmon]

Hi all,

I have an excel macro that sends a project list update to a different department via Outlook. The idea is to send them the up-to-date list whenever they send an email requesting it. Outlook should see their email, open the appropriate excel workbook on my computer, and run the macro saved on that workbook.

Is this possible?

I appreciate any help you can provide.

[JEC.]

You could try something like this behind your ThisOutlookSession

Please Login or Register  to view this content.

[carlmon]

Please Login or Register  to view this content.

Thanks, JEC, I am going to give this a try today.

For the line I have highlighted in red, do I need to change that to the name of the file?

And does it matter if this is saved to one drive? The folder path is linked on my computer ( I don't have to visit the web to open the file )

[carlmon]

my outlook VBA editor got stuck in a "running" state when the code fired. Not sure what happened exactly

Edit: I already had it opened - I'm going to try and write something that says if it's already opened then fire the macro

[JEC.]

Yes you need to change the name of the file there

[carlmon]

disregard -------

[carlmon]

disregard ------

[carlmon]

disregard ---------

[carlmon]

JEC, would the code fire if Troy or Robert sent me an email and the subject is "Update"? I'm not familiar with outlook objects/properties

Please Login or Register  to view this content.

[JEC.]

Yes it should work this way. Make sure you have the correct name. First and last name probably.

[carlmon]

It's working great. Before I close this one out, sometimes the macro in ThisOutlookSession doesn't fire unless I re-open Outlook. Do you know why this happens?

Edit: I removed their last name for their privacy... I don't care if my full name is out there but I'm not sure they would feel the same way.

[JEC.]

Try to put the code in a Class Module. How is that?

[carlmon]

Works well. Thanks again

[JEC.]

You’re welcome!