The SendObject action can attach a MS Access form, table, report or query in an Microsoft Access SendObject Syntax. ject [type][, name][. I’ve recreated as best I can what from you’ve described above and it all ran ok for me. You can have a look at what I’ve got here for clues; use. ject in MS Access database Docmd SendObject sample code and download for sending email using the sendobject method.
|Published (Last):||12 October 2013|
|PDF File Size:||5.63 Mb|
|ePub File Size:||1.5 Mb|
|Price:||Free* [*Free Regsitration Required]|
Invalid email addresses are provided in an error table.
SendObject Method of MS Access | Database Solutions for Microsoft Access |
Header and footer information is also not included.
All other controls are ignored. Attachments are in addition to the message. I want to be able to click on a name field and send an email to that person.
This works in Access andand I believe its the same code I used in at another job. Although the accesz are fairly limited, it works even with no MAPI compatible mail client installed.
To use the active object, specify the object’s type with the objecttype argument and leave this argument blank. Would you like to provide feedback? The SendObject action can attach a MS Access form, table, report or query in an electronic mail message.
The syntax information comes from the Microsoft VBA online help system with additional edits for clarification. Send 2001 email with VBA and Outlook using a specific sender account. Bcc Optional Variant A string expression that lists the recipients whose names you want to put on the Bcc line in the mail message. If you want to include the active object in the mail message, specify the object’s type with the ObjectType argument and leave this argument blank.
Create an email with Outlook-Automation. Total Access Emailer includes syntax checking to validate the format of the email addresses you are sending to catch errors before sending the message. If you leave this argument blank, Microsoft Access prompts you for the recipients.
Discuss this further in our blog. Total Access Emailer lets you compress multiple files into one zip file for faster transmission. Total Access Ultimate Suite. Just a few questions before I go any farther 1. Forum and Ticket Submissions. Sometimes though you need to send an email with a specific sender account. You can send table, query, and form datasheets.
It only uses the email to set the account. SendObject Visual Basic command.
DoCmd.SendObject method (Access)
Access Access Emailer lets you specify the FROM address of your email which can be explicitly set or from a field in your data source. If you leave this argument blank, the Cc line in the mail message is blank. SendObject method or the EmailDatabaseObject macro action.
The output format of the object being sent: