CHECK duplicate email

User avatar
sal21
PlatinumLounger
Posts: 4374
Joined: 26 Apr 2010, 17:36

CHECK duplicate email

Post by sal21 »

in a subfolder of root of my personal email have a dir SERVIZIO.
Into this dir have many email where the subject contain a part of subject text is similar (1254887788-325).
example:
subject: aaaaaa (1254887788-325)
subject: aaaaaa (1254887788-325)
...
subject: aaaaaa (1254887788-325)

i need to loop all email end maintain in SERVIZIO one copy pf that... delete the duplicates with the same subject

How to via vba for excel and outlook?
tks.

User avatar
Rudi
gamma jay
Posts: 25455
Joined: 17 Mar 2010, 17:33
Location: Cape Town

Re: CHECK duplicate email

Post by Rudi »

Do you need to have a VBA solution?
Here is a freeware add-in for Outlook to remove duplicate emails... see here: http://www.outlookfreeware.com/en/produ ... uplicates/
Regards,
Rudi

If your absence does not affect them, your presence didn't matter.

User avatar
HansV
Administrator
Posts: 78642
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: CHECK duplicate email

Post by HansV »

If you still prefer VBA, see:

VB Macro for deleting or detecting duplicate Outlook Mails (it works from an Excel workbook!)
Best wishes,
Hans

User avatar
sal21
PlatinumLounger
Posts: 4374
Joined: 26 Apr 2010, 17:36

Re: CHECK duplicate email

Post by sal21 »

Rudi wrote:Do you need to have a VBA solution?
Here is a freeware add-in for Outlook to remove duplicate emails... see here: http://www.outlookfreeware.com/en/produ ... uplicates/
YES.. i need to check dupes via vba code :thankyou: :grin:

User avatar
Rudi
gamma jay
Posts: 25455
Joined: 17 Mar 2010, 17:33
Location: Cape Town

Re: CHECK duplicate email

Post by Rudi »

HansV wrote:If you still prefer VBA, see:

VB Macro for deleting or detecting duplicate Outlook Mails (it works from an Excel workbook!)
Nice find :thumbup:
Regards,
Rudi

If your absence does not affect them, your presence didn't matter.

User avatar
sal21
PlatinumLounger
Posts: 4374
Joined: 26 Apr 2010, 17:36

Re: CHECK duplicate email

Post by sal21 »

HansV wrote:If you still prefer VBA, see:

VB Macro for deleting or detecting duplicate Outlook Mails (it works from an Excel workbook!)
or i'm a stupid or the code have a few error... :scratch:

User avatar
HansV
Administrator
Posts: 78642
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: CHECK duplicate email

Post by HansV »

Please provide detailed information.
Best wishes,
Hans