In the Mail Merge toolbar, select the Open Data Source button. Navigate to the Seminar Attendees file and click Open. Select the name of the worksheet that contains the data.

When a simple mail merge isn't enough, consider adding conditional fields to clarify data and even make decisions.

Your options include New Data Source, Open Data Source, Office Address Book (the one found in Outlook), Apple Address Book (Apple’s Address Book application), and FileMaker Pro.

In part three, you're finally ready to use the data you exported from Outlook to Excel, to create a mail merge with a Word document.