Send a database object's output as an attachment to an e-mail message

1. In the Database window, click the type of database object you want under Objects, and then click the name of the database object you want to send as an attachment.

   If you want to send a selection of a datasheet, open the datasheet and select the portion of the datasheet before continuing.

2. On the File menu, click Send To and then select Mail Recipient (as Attachment).
   
   
3. Click the file format you want to attach, and then click OK.

   Microsoft Access opens a new e-mail message and attaches the output of the object in the format you selected.

4. Enter recipient names in the To and Cc boxes. Separate names with a semicolon (;).

   To select recipient names from a list, click To or Cc. The name of the object is displayed in the Subject box by default, but you can type your own subject name. You can manually check names before sending the message. You can also set additional options for the e-mail message.

5. Click Send on the message header.

Notes

• You can attach a database object in an e-mail mail message in one of the following output formats: HTML (.htm, .html), Microsoft Excel (.xls), Microsoft MS-DOS text (.txt), Rich Text Format (.rtf), in the case of a data access page, data access page (.htm, .html), or, in the case of a report, report snapshot (.snp).
  
  
• Although you cannot attach a database object in either Microsoft Internet Information Services (.htx, .idc) or Microsoft Active Server Pages (.asp) output formats, you can export the object to the desired output format and then attach the files in a mail program, such as Microsoft Outlook. Learn about exporting data.
  
  
• You can only send a page in data access page (.htm, .html) output format. You can only send modules in MS-DOS text (.txt) output format. You cannot send macros or database diagrams (Microsoft Access project only).