Microsoft Access 2010 Bible

Part III: More-Advanced Access Techniques

818

To manually process each reply, you have to use Outlook 2007 or 2010. The replies reach your

Outlook destination folder, but they aren’t processed automatically. To process a reply manually,

right-click the reply, and then click Export Data to Microsoft Office Access from the pop-up menu

(shown in Figure 22.18). The resulting dialog box lets you verify the information being updated;

click OK to process the data.

FIGURE 22.18

Process replies manually from Outlook.

Summary

In this chapter, you learned how to use Automation to interact with other applications. You

learned about the Automation references and how to create Automation objects. Then you used

Automation to take control of the Word object to insert data from Access into a Word document

using Word’s bookmarks. You used Word’s macro recorder to generate VBA code, so you don’t

have to learn Word’s object model.

You also learned how to collect data using Microsoft Outlook 2007 and 2010. You walked through

the steps to create an e-mail to update the data in the Customers table, sent the e-mail, and mon-

itored the replies. Using Outlook and Access together lets you gather information from users with-

out doing data entry or giving them access to your application.