asked on 9/5/2018

Need help to trigger outlook macro automatically when new email comes in Specific folder

Hi Experts ,

I have a Independent folder in Outlook named "Test" .
I have macro whose work is to get the attachment from "Test" folder emails and save at"EmailAttachments" folder in "MyDocuments"

So the program is working when I manually run the macro , So I need your help to set some program which can run this macro automatically .
The program should run when new email comes in "Test" folder only otherwise if it will check inbox and all outlook then it will be performance issue.

I am using below code in "ThisOutlookSession" but it is checking all incoming emails in outlook , just need to check "Test" folder only.

Private Sub Application_NewMail()
    Call SaveAttachments
End Sub

Open in new window

Also "Run as Script" is not available.

Appreciate any help in this regard.

VB Script Outlook VBA

Last Comment

Afzal Khan

9/6/2018

Shimshey Rosenberg

9/5/2018

How are the emails getting into the test folder? Is it with a rule?
You can utilize the same rule to run a script.

See this link;
https://www.slipstick.com/outlook/rules/outlook-2016-run-a-script-rules/

Afzal Khan

9/5/2018

ASKER

Shimshey the emails are coming through Outlook rule , Unfortunately "Run as Script" is not available in outlook due to security reasons.

Shimshey Rosenberg

9/5/2018

What are you looking help with? running it only on a specific folder? or running it automatically?

Afzal Khan

9/5/2018

ASKER

I need help to run the macro automatically when new email comes only to that folder"Test" , As of now I am manually running it.

ASKER CERTIFIED SOLUTION

Afzal Khan

9/6/2018

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial