This VBA macro removes duplicate emails from the currently selected Outlook folder. It checks for duplicates based on the email's subject, sender, received time (excluding seconds), and body content.
- Identifies and removes duplicate emails from the active folder.
- Provides a progress bar to indicate processing status.
- Displays the number of emails removed upon completion.
- Microsoft Outlook
- Basic understanding of VBA
- Open Outlook.
- Press
Alt + F11
to open the VBA editor. - Import the
RemoveDuplicateEmails.bas
andProgressForm.frm
files:- Go to
File > Import File
. - Select the
.bas
file and.frm
file.
- Go to
- Close the VBA editor and return to Outlook.
NOTE: Make sure that all 3 files 'RemoveDuplicateEmails.bas`, 'ProgressForm.frx' and 'ProgressForm.frm' exists on the same directory while improting. however you dont have to import 'ProgressForm.frx' at all, it will be imported automatically.
- Navigate to the folder where you want to remove duplicate emails.
- Press
Alt + F8
to open the macro list. - Select
RemoveDuplicateEmailsSafely
and clickRun
.
This project is licensed under the MIT License. See the LICENSE file for details.