Course Details
Course Details
Course ID
8534
Course Name
Mail Merge for Water Utilities
Contact Hours
3.0
Approved Industry
Drinking Water and Wastewater
Partner Name
Pennsylvania Rural Water Association
Primary Contact
Joel Jordan
jjordan@prwa.com
8143539302 Ext. 201
Website
Description
This course will explain the steps to perform a mail merge using Microsoft Word and Microsoft Excel. Mail merges can save hours of time and reduce errors in the process of sending out a large number of letters, bills, and notices to multiple addresses. We will learn a few basic tricks in Microsoft Word to create an organized and sharp looking water utility bill template and then use data from an Excel spreadsheet to automatically address letters to all water utility customers on a list. We will also explain why we should use mail merges, other software packages that can be used, and a few practical applications of mail merges.
Course Level
Basic thru Intermediate
Course Content
What is Mail Merge?
First Create the Data File
Second Create the Letter
Third Perform the Merge
Target Audience
Water utility managers, operators, and support staff
Training Format
Virtual Asynchronous