How to Email an Access Table

Save

Microsoft Access databases have several components. The items that house the raw data of a database are tables. The information in a table can be imported from another program or entered directly into an Access database table. If the information in a table needs to be sent to another party, it does not need to be reentered, it can be emailed.

  • Open the database.

  • Click on the "Create" tab.

  • Go to the "Macro" option. The icon resembles a gold inverted "S." Click on the down arrow under the Macro icon and click on "Macro."

  • Click on the down arrow under the Action field and go to the "SendObject" command.

  • Select "Table" in the Object Type field in the Action Arguments segment of the Macro tab. In the Object Name field, click on the down arrow to select the name of the table to email. For the Output Format, leave it blank. This will prompt Access to ask the user in which format to export the table (e.g., .xls for Excel).

  • Type the email address in the To: field. If the table must also be carbon copied (Cc) and/or blind copied (Bcc) to others, type their email addresses in the Cc and Bcc fields respectively.

  • Type the subject of the email in the Subject field and the text of the message in the Message Text field. To edit the message in the email application, click on the down arrow in the Edit Message field and select "Yes."

  • Save and name the macro in the"Save As" dialog box. Run the macro by clicking the exclamation point in the upper left corner.

Tips & Warnings

  • The computer's email client, such as Outlook, will be used to send the table via email.
  • If the Edit Message field is "No," the macro will not run.

References

  • Photo Credit email @ image by Witold Krasowski from Fotolia.com
Promoted By Zergnet

Comments

Resources

You May Also Like

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!