Home →
REMMS →
Quick Tips and Finds →
Create a Mail and Email merge file
12.1. Create a Mail and Email merge file
Many programs provide the ability to perform a mail merge or email merge. Aside from Microsoft Word, there are programs that one can use to send out braodcast emails to different groups. One common program is called GroupMail.
All of these programs rely on a data merge file which contains the "people" that you want to send messages to. Below are instructions on how to create this file.
- Go to the Member Module
- Click on the Utility button
- Select Export to Mail Merge under the Export Routines heading
- You will be prompted to select your criteria for the find
- Click on the Committee TAB on the top portion of the screen (This is NOT the Committee button)
- Click in the Committee ID field and select the committee you want
- Click in the Committee Year field and type in the year (i.e. 2009)
- Click on Continue to complete the find
- Your results will be sent to a text file called _Email.txt on your C: drive (C:\_Email.txt)
You will now be able to edit this information in Excel or a regular text editor.