Xlsm file containing VBA and forms for Excel for managing the email addresses in any number of folders and contact groups in Microsoft Outlook.
Reads email addresses from an Excel spreadsheet, end-user can then choose to, on a column-by-column basis:
- Add the new email addresses
- Delete existing email addresses
- Update existing email addresses.
Includes a form to select the folders and contact groups in Microsoft Outlook to work with.
Includes a form that asks what to do with the email addresses in each column of the Excel spreadsheet: add, delete, update, or ignore.
Validates the email addresses in the spreadsheet, flagging and not reading any improperly formatted email addresses.
Silently refuses to:
- Add pre-existing email addresses
- Delete non-existent email addresses
- Update non-existent email addresses.
Flags and ignores email addresses listed in more than one operation:
- Duplicate operations.
- Add and Delete.
- Add and Update.
- Update and Delete. Assumes that email addresses are listed in more than one operation due to typos or other mistakes.
Package is an xlsm file including:
- All VBA and forms
- An Excel spreadsheet with instructions on running the code
- 7 spreadsheets of test cases for testing the VBA
- 1 spreadsheet with data for stress testing the entire application.