This course is designed for those delegates who need to produce mass letters, emails or labels that are sent to many people. Each letter/email has the same kind of information, yet the content is unique. For example, in letters to your customers, each letter can be personalised to address each customer by name. The unique information in each letter comes from entries in a data source i.e. Excel, Outlook contacts.


On completion of this course, attendees will be able to create a mail merge to produce letters, emails and labels.


Attendees should have a good basic understanding of Word prior to attending this course.


Courses are delivered in 2010, 2013, 2016, 2019 & O365

What will I learn?

Create the Data Source

  • Data Source options i.e. Excel, Outlook
  • Create a data source to be used in a Mail Merge

Use Mail Merge to Create Letters

  • Start the Mail Merge
  • Select recipients – Type a New List, Use an Existing List, Select from Outlook Contacts
  • Write your letter and insert merge fields
  • Preview your letters before merging
  • Edit recipients before merging
  • Sort and Filter records
  • Complete the merge
  • Edit individual documents
  • Print documents

Use Mail Merge to Create Address Labels

  • Start the Mail Merge
  • Select Recipients
  • Insert merge fields
  • Preview your labels before merging
  • Edit recipients before merging
  • Complete the Merge

Use Mail Merge to Send E-mail Messages

  • Start the Mail Merge
  • Select Recipients
  • Write your email and insert merge fields
  • Preview your e-mail before merging
  • Edit recipients before merging
  • Complete the merge
  • Save the e-mail message main document
  • Send the e-mail messages

Specify Rules for the Mail Merge

  • Insert Ask… fields
  • Insert Fill-in… fields
  • Insert If…Then…Else fields

Envelopes and Labels

  • What if I just want to print a single label or envelope?
  • Create and print single envelopes and labels

How we deliver

Training can be delivered in either of the following ways:

  • Online

    Online training is ideal if you have staff in different geographical locations who have the same Microsoft or Adobe training requirements.

    Our expert trainers can deliver Watch and Learn sessions to up to 100 people. Alternatively, they can produce an interactive session that allows delegates to complete practical exercises within the Microsoft or Adobe apps of your choosing.

  • Face to face

    Choose from one or half day training sessions or our popular 90-minute Sprint sessions, which can be delivered in your offices or at another location of your choice.

    All we need is a room with a table and chairs and we look after the rest. We can even provide laptops and a projector should you not have spare IT equipment to use.

Sprint learning

Short on time, but still want to boost staff performance?
Book a Sprint Session!

Each Sprint Session follows a 90-minute format for ultra-focused team learning.

Pick a topic, tell us what you want to achieve from your session, and we’ll put together a short, fun, entirely bespoke programme that meets the needs of your team.

Designed to cater for 10-15 delegates at a time

Developed by our team to cover the subject matter of your choice

Delivered online or face-to-face

Stay up to date

Subscribe to our mailing lists:

I would like to receive the following emails:
Mailing lists

We are collecting your email address to send you the emails you select above and we require your consent. By clicking the Subscribe button, we are treating this as your consent. To withdraw your consent, please use the unsubscribe option at the bottom of the received email(s)