Access.2007.VBA.Bibl..

As an example, the Microsoft record in my personal Access Contacts database has 30 phone num- bers, many with non-standard descr ...

FIGURE 8.1 Ribbon choices for exporting Access data. FIGURE 8.2 The Collect Data group on the Access Ribbon. Using the Import Gr ...

FIGURE 8.3 The Outlook Folder selection in the Import group on the Ribbon. Selecting the Outlook Folder selection on the More me ...

After selecting the “Link to the data source by creating a new table” option (shown in Figure 8.5) and clicking OK, the Link Exc ...

FIGURE 8.7 A linked Outlook Tasks folder, lacking the Subject field. The linked olCalendar table (shown in Figure 8.8) does incl ...

FIGURE 8.9 A linked Contacts folder. Working with Outlook Items 8 Creating a Database from a Template T o create a database from ...

Part II Writing VBA Code to Exchange Data between Office Components continued If the template you want to use is displayed in th ...

Working with Outlook Items 8 Opening the Templates page on the Microsoft Office web site. On the Databases page, you have a choi ...

Part II Writing VBA Code to Exchange Data between Office Components continued In the Access 2007 group, you’ll see several categ ...

Working with Outlook Items 8 Click the template you want to use to open a page with a Download link. A download link for the Tas ...

Using Sample Databases and Forms ........................................................................ I created Events and T ...

FIGURE 8.11 The Task List form, imported from a database created from the new Tasks database template. FIGURE 8.12 The Event Lis ...

FIGURE 8.13 The Contact List form, imported from a database created from the new Tasks database template. These forms from the n ...

All of these forms from the new database templates use the new embedded macros instead of VBA code for various purposes. Using m ...

The Outlook Object Model .............................................................................................. Because ...

FIGURE 8.16 Outlook Explorer and Inspector objects. The NameSpace, Explorer, and Inspector objects, in addition to the Applicati ...

in a folder, you also need to declare a variable as Object. This is because a variable of the Object type may represent items of ...

Create a standard item using the CreateItemmethod of the Application object: Set msg = appOutlook.CreateItem(olMailItem) Create ...

In the Choose Form dialog, select “User Templates in File System” from the “Look in” drop-down list, as shown in Figure 8.19. FI ...

Test whether the current folder is a Contacts folder: If fld.DefaultItemType <> olContactItem Then MsgBox _ “This folder i ...