|New! Download Access example of the Sendobject Method|
If you want to include the active object in the
Email message, specify the object's type with the objecttype argument and leave this
argument blank. If you leave both the objecttype and objectname arguments blank (the default constant, acSendNoObject, is assumed
for the objecttype argument), Microsoft Access sends a message to the
Email application without an included database
object. If you run Visual Basic code containing the SendObject method in a library database, Microsoft Access looks for the object
with this name first in the library database, then in the current database.
OutputFormat - Optional Variant.
To - An optional string expression that lists the recipients whose names you want to put on the To line in the E-mail message. Separate the recipient names you specify in this argument and in the cc and bcc arguments with a semicolon (;) or with the list separator set on the Number tab of the Regional Settings Properties dialog box in Windows Control Panel. If the recipient names aren't recognized by the Email application, the message isn't sent and an error occurs. If you leave this argument blank, Microsoft Access prompts you for the recipients.
Cc - An optional string expression that lists the recipients whose names you want to put on the Cc line in the mail message. If you leave this argument blank, the Cc line in the mail message is blank.
Bcc - An optional string expression that lists the recipients whose names you want to put on the Bcc line in the mail message. If you leave this argument blank, the Bcc line in the mail message is blank.
Subject - An optional string expression containing the text you want to put on the Subject line in the mail message. If you leave this argument blank, the Subject line in the mail message is blank.
MessageText - An optional string expression containing the text you want to include in the body of the mail message, after the object. If you leave this argument blank, the object is all that's included in the body of the mail message.
EditMessage - Optional - use True (�1) to open the electronic mail application immediately with the message loaded, so the message can be edited. Use False (0) to send the message without editing it. If you leave this argument blank, the default (True) is assumed.
TemplateFile - Optional string expression that's the full name, including the path, of the file you want to use as a template for an HTML file.
More Send Object Samples & Examples:
|SendObject Visual Basic command. We've
added a little trick to the send object command in that we use the
NoObject option to not really send anything to ...
A Blue Claw Software Design Template:
Investment Account Management Software
A Blue Claw Database Design Article:
Repair Corrupted Access Table
Blue Claw Database Design Downloadable Tutorial:
DoCmd.OpenForm & OpenArgs VBA Example.
Copyright 2000-2017 Blue Claw Database Design