Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Varun Kumar Kandimalla (VarunKumarK0034)
Statefarm Insurance

Statefarm Insurance
US
VarunKumarK0034 Member since 2019 2 posts
Statefarm Insurance
Posted: Oct 29, 2019
Last activity: Nov 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.

To see attachments, please log in.
Robotic Process Automation

Posted: 5 years ago
Posted: 30 Oct 2019 13:14 EDT
Thomas Sasnett (ThomasSasnett)
MOD
Lead Robotics Architect
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.

To see attachments, please log in.
Posted: 5 years ago
Posted: 6 Nov 2019 8:47 EST
Varun Kumar Kandimalla (VarunKumarK0034)
Statefarm Insurance

Statefarm Insurance
US

Thanks for response. I have tried Retrieve Email method scenario and it’s worked. And also i have tried C# script to get Emails Count with Duplicate Subject. 

To see attachments, please log in.
Posted: 5 years 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
To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice