Access.2007.VBA.Bibl..

FIGURE 4.6

A journal item created from a record in a table of mainframe transaction data.

Creating Emails from an Access Table..................................................................................

If you have an Access table (say, of customer, client, or contact information) with email addresses,

you can create emails to people in the table directly from an Access form, so you don’t need to

open Outlook to create an email, which can save time. tblContacts in the sample database has an

Email field with the contact’s email address, and the form frmEMail (Figure 4.7) lets you send

emails to contacts selected from a multi-select ListBox.

FIGURE 4.7

A form for selecting contacts as email recipients.

Organizing and Communicating with Outlook 4