‘Allow the user to select a folder in Outlook
Set AppOL = CreateObject(“Outlook.Application”) ‘Set a reference to the Microsoft Scripting Runtime from Tools, References. The macro can be run by clicking the button on the worksheet. The macro is setup in an Excel workbook for simplicity. Duplicate emails are then deleted leaving only one unique copy of each email in the folder. The macro will process all emails in a specified folder and compare the subject and body to the other emails in the same folder. If you do not keep your emails organized it can eventually get out of control. This can occur if multiple imports from PST files have occurred, or if you receive emails from different email accounts and end up getting CC’ed on multiple accounts. The purpose of the following macro is to delete duplicate emails from an Outlook folder. Or download the Microsoft Excel workbook from our website, and run it from there. Simply use the code below which was written by Jacob Hilderbrand – Microsoft Excel MVP, to do the grunt work for you. Well that is possible, thank you to Jacob. In this case it would be nice to have an Excel Macro that would do it for you, all with the click of a button. Do you have the need to delete duplicate emails from Microsoft Outlook? Perhaps you have accidentally created hundreds of duplicates, and your pst file is so vast you do not have the time nor the energy to remove each of them manually.
0 kommentar(er)
