Sending Access Objects in Email

Remember earlier when you wanted to share your catalogs with your gardening friend? Well, you could export that data to a disc or simply send the data to her via email. Certainly, if you both have email, that would be the easiest choice. Fortunately, Access 2003 makes sharing data via email extremely easy. In this next exercise, you send the catalog data to yourself using email. Follow these steps:

  1. In the Database window, click the Tables shortcut and select Catalogs.

  2. Select Send To from the File menu.

  3. The resulting submenu offers two options, but only the Mail Recipient (As Attachment) is enabled, so select it.

  4. In the Send dialog box, choose a format for the data you're sending. Table 16.1 explains the various options. For this example, select Rich Text Format (*.rtf), and then click OK.

  5. Access uses your default email software to display a new message that contains the Catalogs table as a text attachment (remember, you selected Text File in the previous step). Address the email to yourself.

  6. Click Send.

Download and open the email to view the attachment, shown in Figure 16.12. The .rtf file keeps most of the table's formatting, which makes the data easy to view. The text file isn't the greatest because it tries to maintain some of the table's properties.

Figure 16.12. Access was able to send the catalog data via your email account.


Table 16.1. Email Format Options

Send Option


Rich Text Format

Sends the data as an .rtf file (a type of text file that retains some formatting).


Sends the data as a text file (tabular).


Sends the data in Excel format (be sure to select the appropriate version).


Sends the data in a Web-ready file.


Sends the data as a Snapshot document.



In this section, you'll send email to yourself. That means you must have an Internet connection and an email account with a server (probably an Internet service provider or a service such as AOL). Without an email account, you can still go through the steps, but you can't actually send and then receive the email.

Sharing Reports

Access reports contain a lot of formatting that can be lost when you share them outside your database. If you send a report via email as an .rtf file, it will retain some of its formatting. (The .rtf is the same format you used to send the Catalogs table in the previous section.)

A better choice is to use a special format known as a snapshot ( .snp ). This format produces a high-quality copy of each page in your Access report. Using this format, you can send a report and the receiver will have an exact copy of your Access reportboth the data and the formatting, including graphics. Best of all, the recipient doesn't need Access to view the report as if it were in Access! The magic that makes this possible is a small program known as Snapshot Viewer that you install when you install Access. Users without Access can download the Snapshot Viewer separately from Microsoft's Web site.

Let's create a snapshot file of the Catalogs report by doing the following:

  1. Click the Reports shortcut in the Database window and select CatalogsAuto.

  2. Select Send To from the File menu, and then select Mail Recipient (As Attachment) from the submenu.

  3. In the Send dialog box, select Snapshot Format and click OK . (The other options are basically the same as described earlier in Table 16.1.)

  4. Enter your email address (so you can mail the report to yourself), and click Send.

  5. After sending and retrieving the email, open the report attachment. Figure 16.13 shows the Catalogs report in the Snapshot Viewer window.

    Figure 16.13. The report automatically opens in Snapshot Viewer.


The report looks exactly like the Catalogs report in Access. Notice that the Snapshot Viewer window even has a menu of options so you can print or email the report to someone else.

Absolute Beginner's Guide to Microsoft Office Access 2003
Absolute Beginners Guide to Microsoft Office Access 2003
ISBN: 0789729407
EAN: 2147483647
Year: 2002
Pages: 124

Similar book on Amazon © 2008-2017.
If you may any questions please contact us: