You can send an Access object through email in a variety of formats. For example, you can email a report to a user as a PDF file or a query to a distribution list as an Excel workbook.
Procedure
Do one of the following:
- Select the object in the navigation pane.
- Open an object and make sure it is the currently opened object. In this case, you can also select some content, such as a few rows in a datasheet.
Select External Data > Email.
The Send Object As dialog box appears.Under Select output format, select one of the available formats.
Under Output, select All or Selection:
- If you selected some content in step 1, the default option is Selection, but you can still select All.
- If you didn't select some content, these options are dimmed and not available. All the content is sent.
Select OK.
Outlook opens a new message with the object attached in the format you selected.In the message, do the following:
- On the To line, Cc line, , and Bcc line, enter an email alias, aliases separated by a semicolon, or distribution list.
- In the message body, enter text.
When you are done, select Send.