Question
3
Replies
44
Views
Statefarm Insurance
Posted: October 29, 2019
Last activity: November 6, 2019
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.
Posted: 1 year ago
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.
Posted: 1 year ago
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;
}
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.