Mail Merge: Using Excel & Word

2 sessions of 2.5 hours each

Mail Merge allows you to create multiple documents at once, such as letters, mailing labels, and envelopes by incorporating data from Microsoft Word and Excel saving you the time and effort of retyping the same letter over and over, or handwriting many envelopes. We use Mail Merge for writing a personalized letter to many people at the same time. The content of each letter is the same except for the recipient’s personal information: e.g., name, address, policy number (if you have a small business), etc. Prerequisite: Basic knowledge of Word and Excel.

This class is for Word versions for Windows & Mac included in Microsoft Office releases from 2010 through 2021 and all releases of Microsoft 365 (formerly called Office 365).

Pre-requisite: Basic functions in Word (type a plain document) & Excel (create a basic spreadsheet).

Lesson 1 – Form Letters

Using the data from the Excel spreadsheet, you will personalize a form letter for each recipient.

Lesson 2 – Labels & Envelopes

Using the data from the Excel spreadsheet, you will create personalized Labels (Avery) and Envelopes.

The SeniorNet Advantage

Hands-on instruction● Individual attention● One student per computer
● Manuals included● Friendly atmosphere● Seniors teaching seniors