Course Description:

Need to learn how to create a batch of personalized letters or emails to send to your professional contacts?  In this new, project-based workshop, we will 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 we will merge 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: Nov.28, 2:30-4:30 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.
• If you are not on campus and would like to attend this course remotely via Zoom, please email a request to computer.training@uwyo.edu at least 24-hours before the listed start time.  Remote course attendance is not available for all workshops, and may have specific requirements.
• Workshop fees are non-refundable (unless the class is cancelled by UWIT Training).