Mail Merge in Microsoft Word

We can combine data in Microsoft Access  with letter creation in Microsoft Word.

This tutorial will show us how to do that.

---

Make your query

open the employee meeting database as edited in the last few lessons

Using the "Between Date() and Date()+30" criteria search to find all meetings that are happening within the next month.

save that query.

Important: Close the database.

---

Performing the Mail Merge

1.) Open Microsoft Word and a new document and call it "meeting reminder" Save it.
2.) Click "Select Recipients".
3.) Click "Use an Existing List".
4.) Navigate to your the employees/meeting database.
5.) Your query should appear in the list of tables

8.) Add last name as well.
9.) Click "preview results"

Task: Using your Microsoft Word Skills create a reminder letter to be send out to the employees.

Click "Finish and Merge" to create a document with all the letters.

6.) Click OK after selecting the query.
7.) Now you can insert fields from the database. To do this Click Select Fields and insert "First Name".

---

Smite thy Enemies

Create a letter to send to your enemies in the friends database who have borrowed overdue items.