The Mass Email Tool consists of a Microsoft Excel worksheet and Microsoft Word memo document saved together in a compressed folder. The files contained within the Mass Email Tool have built-in macros (pre-programmed processes that run within Microsoft Office files) that accomplish various tasks. To make sure you always have the most up-to-date version of the tool, we recommend you download a new copy of the tool for each new project you begin.

Note: the Mass Email Tool does not currently work in macOS due to macOS's security restrictions.

Files

Download UW-Madison Mass Email Tool (activated version) 
The activated version of the Mass Email Tool sends emails and is intended for real world applications.

Download UW-Madison Mass Email Tool (practice version) 
The practice version of the Mass Email Tool does not send emails and is intended to allow users to practice the Mass Email Tool process without worrying about accidentally emailing people.

Process

Open the compressed folder if it doesn't open automatically. Windows should display a special Extract section in the top bar. Within the Compressed Folder Tools section, select the Extract all button.

By default, Windows will extract the files to the same folder where the compressed folder is. We recommend creating a dedicated folder where you can keep all the files for your project. Click the Browse... button to open the file browser and select or create a new folder to extract the files into. Once you have selected the destination folder, select the Extract button.

Once the files have extracted, Windows will open the new folder to show you the contents. Verify that the files saved where you expected so you can find them later.

The next document will explain the process of setting up the mail merge and email content and settings.