From the course: Office 365: Access Essential Training

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Setting up labels and mail merge documents in Word

Setting up labels and mail merge documents in Word - Microsoft Access Tutorial

From the course: Office 365: Access Essential Training

Start my 1-month free trial

Setting up labels and mail merge documents in Word

- Using the data stored in your Access database you can easily populate mail merge documents in Word to create personalized letters and other types of correspondence. In order to start, we need to gather the records that we want to export out to Word. So we could do that with a simple query. I'll go ahead and start with the Create tab and jump into a new query design environment. I'm going to add in information from our Guests table and our RoomAssignments here, and close the Show Table window. Now, I want to create a letter that's tailored to guests of the hotel, that have an upcoming visit scheduled. I'm going to grab the FirstName and LastName by double-clicking on them here in the Guests table, and then over here on the RoomAssignments table, I'll double-click on CheckinDate. Now I don't want everybody with a check-in date on the RoomAssignments table, I only want the ones that have an upcoming visit. So I'm going to come down here to the Criteria and I'll just right-click it and…

Contents