Chapter 22: Integrating Access with Other Applications
813
FIGURE 22.13
Select the fields to add to the e-mail form; then set the caption and select the Read Only
check box for each field.- Specify the field in the database that contains the recipient’s e-mail address.
Your options are
l The Current Table or Query: If the e-mail address is in the e-mail form’s table or
query, select the Current Table or Query option and select the field — in this example,
the EMailAddress field.l (^) An Associated Table: If the e-mail address is in an associated table, you have to select
the Associated Table option. Then select the field in the current table that identifies
who receives the e-mail, the associated table, and the field in the associated table that
contains the e-mail address.
For this example, select the current table, and then click Next.
- Customize the e-mail message by typing a subject and introduction, and choosing whether
you want the e-mail addresses in the To, Cc, or Bcc field (shown in Figure 22.14). - Accept the default settings, and click Next.
- Review the instructions for managing the e-mails, and click Next again.
- Verify the recipients, and create the e-mail.
- Check all the recipients, and click Send to send the e-mail messages (shown in Figure
22.15).