CODEWITHSUNDEEP
vbaoutlook
TheFlori
TheFlori

Reputation: 69

How to auto respond to CC only?

I created a Mailbox to forward E-Mails to.

This Mailbox will automatically create a JIRA Issue in our JIRA Project. Sender will be assignee and persons in CC will be watchers.

To avoid questions about the status, we want an auto response, so colleagues know that we have received it.

The Outlook rule "Automatic response from Server" responds to the sender of the E-Mail, not to all, not to the persons in CC.

We want an auto response to all, including CC or better only to the persons in CC.

Can we create a VBA Script for that? Will the VBA Script be executed if my Outlook is offline?

Upvotes: 0

Views: 171

Answers (1)

Eugene Astafiev
Eugene Astafiev

Reputation: 49435

You can develop a VBA script for sending automatic replies according to your needs. But it can be executed only while the host application (Outlook in your case) is running.

The NewMailEx event of the Application class fires once for every received item that is processed by Microsoft Outlook. The item can be one of several different item types, for example, MailItem, MeetingItem, or SharingItem. The EntryIDsCollection string contains the Entry ID that corresponds to that item. You can use the Entry ID returned in the EntryIDCollection array to call the NameSpace.GetItemFromID method and process the item. Use this method with caution to minimize the impact on Outlook performance.

In the NewMailEx event handler you can create a response to the incoming email and send it back. You may find the following articles helpful:

Upvotes: 2

Related Questions