How to Insert Text in an Email with Access
Microsoft Access is a database program that lets users hold and manipulate information in one place. Access has components such as tables, queries, forms, reports and macros. Tables hold information, queries manipulate it, forms provide a way to enter information into tables and reports present the information in a printer-friendly manner. Each of the objects can be sent in an email along with a message about the object. Learn how to insert text into an email using Access.
Other People Are Reading
Instructions
-
-
1
Open a Microsoft Access database.
-
2
Click on the "Create" tab.
-
-
3
Click on the "Macro" option. This allows the database builder to automate a task.
-
4
Click the down arrow under the "Action" field and go to the "SendObject" command.
-
5
Click the down arrow and go to "Table" beside "Object Type."
-
6
Click on the down arrow and go to the name of the table to email beside "Object Name."
-
7
Click on the down arrow beside "Output Format" and select the type of format to place the table in. For example, to send the table in an Excel format, select "Excel Workbook (*.xlsx)."
-
8
Type the email address of the recipient in the "To" field. For example, JohnDoe@acmetools.com would be the proper format for the email address. To carbon copy (cc) or blind-copy (bcc) other recipients, enter their email addresses in the respective fields. Type the subject of the email in the "Subject" line.
-
9
Type the message for the body of the email in the "Message Text" field. Keep the message text succinct. To further edit the text in the body of the email, click "Yes" in the "Edit Message" field. This allows the user to edit the message within the email program.
-
10
Right-click on the "Macro" tab to save and name the macro. Click "OK."
-
11
Click "Run" in the upper left-hand corner to run the macro.
-
12
Click "Send" when the message opens.
-
1
Tips & Warnings
For Windows 7 users, a profile must be created in order to send an email using Access. To set up a profile, click in the Control Panel and go to the "Mail" icon. Follow the directions in the wizard.
