Question

3
Replies
50
Views
 Varun Kumar Kandimalla (VarunKumarK0034)
Statefarm Insurance

Statefarm Insurance
US
VarunKumarK0034 Member since 2019 2 posts
Statefarm Insurance
Posted: October 29, 2019
Last activity: November 6, 2019
Posted: 29 Oct 2019 10:41 EDT
Last activity: 6 Nov 2019 8:50 EST
Closed

Duplicate E-mails

How to find duplicate Emails with subject from Outlook and this duplicate E-mails will have same subject ?

I would like to find solution for task, where I am searching for duplicate E-mails in outlook. (inbox folder). Currently I search for email according to Exact Subject name and Folder where the email is located. I want to search duplicate E-mails with given subject.

Robotic Process Automation
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 1 year ago
Posted: 30 Oct 2019 13:14 EDT
Thomas Sasnett (ThomasSasnett)
PEGA
Lead Robotics Architect u2013 Pega Consulting
Pegasystems Inc.
US

The OutlookConnector has a method called RetrieveEmail where you provide it a folder and a ReadType. This will return a collection of emails from the folder. You can iterate through these by passing that collection to a ListLoop. You can extract a proxy from the Item property and it will represent one email in the collection. From there, you can check the email's properties to do with it whatever you need. In this case, compare the email's subject to the one you are looking for and if it matches, count it or do something to it.
Posted: 1 year ago
Posted: 6 Nov 2019 8:50 EST
Varun Kumar Kandimalla (VarunKumarK0034)
Statefarm Insurance

Statefarm Insurance
US
using System;


using System.Data;


using System.Linq;


using Outlook = Microsoft.Office.Interop.Outlook; 


 


public bool EmailFound(string subj)


        {


            var app = new Outlook.Application();


            var ns = app.Session;


            var inbox = ns.GetDefaultFolder(Outlook.OlDefaultFolders.olFolderInbox);


            var items = inbox.Items;


            bool emailFound = false;


            int EmailCount = (from object n in items


                              where (n as Outlook.MailItem)!= null && (n as Outlook.MailItem).Subject == subj


                              select n).Count();


            if (EmailCount > 1) emailFound = true;


            return emailFound;


        } 


 public int DuplicateEmail(string subj)

Show More
using System;


using System.Data;


using System.Linq;


using Outlook = Microsoft.Office.Interop.Outlook; 


 


public bool EmailFound(string subj)


        {


            var app = new Outlook.Application();


            var ns = app.Session;


            var inbox = ns.GetDefaultFolder(Outlook.OlDefaultFolders.olFolderInbox);


            var items = inbox.Items;


            bool emailFound = false;


            int EmailCount = (from object n in items


                              where (n as Outlook.MailItem)!= null && (n as Outlook.MailItem).Subject == subj


                              select n).Count();


            if (EmailCount > 1) emailFound = true;


            return emailFound;


        } 


 public int DuplicateEmail(string subj)


        {


            var app = new Outlook.Application();


            var ns = app.Session;


            var inbox = ns.GetDefaultFolder(Outlook.OlDefaultFolders.olFolderInbox);


            var items = inbox.Items;


            


            int emailCount = (from object n in items 


where (n as Outlook.MailItem)!= null && (n as Outlook.MailItem).Subject == subj


select n).Count();


            //if (emailCount > 1)


            return emailCount;


        }


Show Less