1

I have a list of senders in Excel (Column A). Based on the mails received from these senders in Outlook, they should be auto forwarded to recipients mentioned in Column B. Since there are more than 500 mails and various senders, it is not possible to create rules in MS Outlook.

I do not have any experience in coding.

Rajul
  • 11
  • 1

1 Answers1

0

You can handle incoming emails in Outlook by handling the NewMailEx event of the Application class which is fired when a new message arrives in the Inbox and before client rule processing occurs. This event 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. Use the Entry ID string to call the NameSpace.GetItemFromID method and process the item. So, you can forward items automatically without using rules.

Also you can automate Outlook from Excel to send emails to the senders listed in the workbook. See Mail from Excel with Outlook (Windows) for code samples.

Eugene Astafiev
  • 47,483
  • 3
  • 24
  • 45
  • Thanks Eugene for your response. I was looking for a VB Code but i will check out your suggestion! – Rajul May 26 '22 at 07:21