Full course description
Need to learn how to create a batch of personalized letters or emails to send to your professional contacts? In this project-based workshop, we work from start to finish through three different mail merge projects. The first project covers how to carefully prepare and clean a list of contact information (in Excel), connect a document to the Excel data source (in Word), create a mail merge letter with merge fields, apply filters so that only records from specified zip codes are merged, and then review all of the resulting personalized letters. The second project covers merging contact information from an Access database into bulk email messages. The final project merges data into printable labels. We will also cover the use of special rules (including how to deal with missing data).
The workshop primarily covers Word mail merge and Excel data preparation skills, along with minor work in an Access database.
Prerequisites: basic experience with Microsoft Word and Excel
Date/Time: Aug.20, 2:00-4:00 PM
Location: Information Technology Center, room ITC171
Instructor: Alec Muthig, UWIT Training
- Send questions regarding this course to email@example.com
- Please make sure to arrive at least 5 minutes before the class is scheduled to begin.
- To attend this workshop remotely using ZOOM, enroll and see the course's main page for a Zoom link. With questions about Zoom, please email firstname.lastname@example.org.
- Workshop fees are non-refundable (unless the class is cancelled by UWIT Training).