Access 2016 Advanced

Access 2016

Lesson 7 – Exporting Data

3. Select . 4. Select the desired file. 5. Follow the steps in the Microsoft Word Mail Merge task pane to complete the mail merge, as desired.



Step-by-Step

Create a Word mail merge document.

Display All Access Objects in the Navigation Pane, if necessary. Open the Customer table in datasheet view.

Steps

Practice Data

1. On the External Data tab in the Export group click the Word Merge button. The Microsoft Word Mail Merge Wizard appears. 2. Select the desired export options. The desired export options are selected.

Click

Click

Link your data to

an existing Microsoft Word document

3. Select OK .

Click

The Select Microsoft Word Document dialog box opens.

4. Select the desired file.

Double-click MAILSHOT.DOCX in the Student Data Folder

The file is opened in Word, and the Mail Merge task pane appears.

After completing the above steps, follow the standard steps in the Word Mail Merge task pane to create your mail merge, as desired. Close EXPORT1.ACCDB .

OFFICEPRO, Inc.

Page 83