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.

For more, see: https://support.office.com/en-us/article/Use-mail-merge-to-create-and-send-bulk-mail-labels-and-envelopes-f488ed5b-b849-4c11-9cff-932c49474705

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

Important Information:

• Send questions regarding this course to computer.training@uwyo.edu
• 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 computer.training@uwyo.edu.
• Workshop fees are non-refundable (unless the class is cancelled by UWIT Training).