Method to launch an VBA code when a specific email is received

When my Outlook account receives an email with a very specific subject and has an attached workbook, I want to have Outlook open up an Excel workbook that contains VBA code that I have already written that 1) Pulls the attached file into Excel, 2) Processes the data, 3) Generates a .pdf file, 4) Creates an email that and attaches the .pdf 5) Send the email to the user defined in the attachment from the original email.

Sounds complicated so I have attached a picture of the flow.Automation Flow.png

Hi Bobbbo,

Since you indicate that items 1 thru 5 are complete, I will focus on the Outlook front end only. What you want can be done in several ways including:
a. Excel Only. This means the Excel file would always be open, and the Excel file would poll Outlook periodically to determine if there are any Emails to be processing.
b. Outlook front end that gets triggered each time there is a new Email Item. Outlook would open Excel (which could incur some overhead each time Excel is opened).

Both solutions require similar code in Excel, because when Excel is triggered, Excel identifies which Emails to process. There may be better ways to do this as I am not an Outlook expert.

Processing is done for Emails that:
a. Have a Specific Subject
b. Are Unread
c. Have one or more Excel attachments

In the Outlook and Excel Macros there are constants that you have to modify to suit your needs:

Please Login or Register  to view this content.

In the Outlook ThisOutlookSession code module:
NOTE: For convenience, the Outlook code is included in a separate code module in the attached Excel File.

Please Login or Register  to view this content.

In the Excel File ThisWorkbook code module:

Please Login or Register  to view this content.

In the Excel File Ordinary Code Module ModOutlookFindEmail:

Please Login or Register  to view this content.

It is a best practice to declare all variables. If you misspell a variable in your code, VBA will silently assume it is a Variant variable and go on executing with no clue to you that you have a bug. Go to the VBA development window, click Tools, Options, and check "Require Variable Declaration." This will insert the following line at the top of all new modules:

Please Login or Register  to view this content.

This option requires all variables to be declared and will give a compiler error for undeclared variables.

Lewis

Thanks LJMetzger, what a through answer. I believe you have provided what I need to get started. I will contact you if I run into issues. Thanks so much!