Support for Database Formats. For example, Total Access Emailer 2016 only works as an add-in with Access 2016. SyntaxTotal Access Emailer is a Microsoft Access add-in, and is Access version specific. Whether it's a list of customers, employees, friends, prospects, or other contacts, email offers an efficient way to communicate with them.Send an email with a database object attached.

When you send a report in HTML format, one. When you send a datasheet, form, or data access page in HTML format, one. To include the activeObject in the email, specify the object's typeWith ObjectType and leave this argument blank.If both ObjectType and ObjectName are blankAccess will send an email without an included database object.An AcFormatType constant that specifies theThe output format of the object being sent.To Names to put in the To line of the email.CC Names to put in the CC line of the email.Bcc Names to put in the BCC line of the email.MessageText Text to include in the body of the emailEditMessage Use True (-1) to open an email applicationUse False (0) to send immediately without editing.Use SendObject() to include the specified Access datasheet, form, report, or module in an email.Access will change much of the formatting when converting to email, forms will display as if in datasheet view, Yes no fields will appear as -1 or 0. Filter Attachments : Total Access Emailer can attach files on-the-fly and filter.ObjectType An AcSendObjectType constant that specifiesObjectName The name of an object to email, of the type selected byThe objecttype argument.

But not for me my role is to be on the bottom of things. The only exception to this is sending a report in Excel format, a text box in a group footer containing an expression with the Sum function will be included in the object.The message text of the email will be in plain text, in many email clients this will by default, render in the Courier New font but the choice of font for plain text emails can be configured under Tools | Options.'email the table T_Sales to two people in a spreadsheet format:DoCmd.SendObject acSendTable, 'T_Sales', acFormatXLS, _вЂњEmail is a wonderful thing for people whose role in life is to be on top of things. Header and footer information is also not included. All other controls are ignored. Xls files), or text boxes and labels (for.