How to Send a Database Object as an Attachment in E-mail 

You can attach most database objects to an e-mail message, except macros and database diagrams (Access project only).

1. In the Database window, click the type of database object you want under Objects, and then click the name of the database object.
   Tip  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, point to Send To, and then click Mail Recipient (as Attachment).
3. In the Send dialog box, click the file format you want, and then click OK. For more information, see About Output Formats You Can Send.
4. Complete the e-mail message. Enter recipient names and distribution lists in the To and Cc boxes, separate names and lists with a semicolon (;), type your message, and set any additional options you want.

   

5. When you are ready to mail the message, click Send on the message header.