The following OPTION parameters are available when the EMAIL value is set to ON. When using EMAIL ON, the printed report document is automatically attached to the email. The EMAIL_ATTACHMENTS parameter is for other external file attachments.
Parameter |
Value |
Description |
ON OFF |
Specifies the report output (defined as FILENAME filename.ext ) to be sent via e-mail as an attachment. |
|
EMAIL_AUTHENTICATION |
ON OFF |
Specifies if the SMTP Server requires user authentication. |
EMAIL_HOST |
value |
Specifies Hostname/IP Address of SMTP Server (Outgoing). Also sometimes known as your 'Sending Mail Server', your SMTP server receives and processes all of your outgoing mail.
For example, your Outgoing Mail Server might be called something like 'my-internet-provider.com' or 'outgoing-mail.mycompany.com'. The SMTP server name is sometimes the same as your incoming mail server name. If your ISP or your network administrator has not given this server name to you, you can leave the box blank. If you do not know what your outgoing mail server name is, you need to contact your Internet Service Provider or Network Administrator. |
EMAIL_PORT |
value |
Specifies the integer value of SMTP Server Port. (Default = 25). |
EMAIL_USERID |
value |
Specifies a valid User Name or Login Name for SMTP Server. This is the name you use to log into your email account. Your ISP or organization provides it. It is generally, but not necessarily, the name that appears before the at sign (@) in your return email address. For example, if your email address was <jim@my-server.com> - then your username would be 'jim' (no quotes). If you do not know what your username is, you need to contact your Internet Service Provider or Network Administrator. |
EMAIL_PASSWORD |
value |
Specifies a valid SMTP Server Password for the user. |
EMAIL_ATTACHMENTS |
value |
Specifies the attached file list. Each file must be separated by the pound character (#). |
EMAIL_BODY |
value |
Specifies the body of the mail. |
EMAIL_DATE |
value |
Specifies the date the message was sent. (Default = .#DATE) |
EMAIL_FROM_ADDRESS |
value |
Specifies the address of the E-mail account from which the mail is to be sent. Sender E-Mail Address (From E-Mail Address:) Enter your e-mail address here. For example, your email address might be 'jim@my-internet-service.com' or 'molly@my-business-domain.com'
Take care not to make a mistake here - or else it will make it difficult for others to reply to your emails. If you do not know what your e-mail address is, you need to contact your Internet Service Provider or Network Administrator. |
EMAIL_FROM_NAME |
value |
Specifies the person's name in an E-mail address. Your real name or what you want to appear as your name on messages that you send out. |
EMAIL_TO_LIST |
value |
Specifies the recipient(s) of a message. Specify the list of valid e-mail address(s) to which the e-mail is to be sent. |
EMAIL_REPLY |
value |
Specifies the delivery address for message replies. This is typically the same as Sender E-Mail Address. Enter your e-mail address here. For example, your email address might be 'jim@my-internet-service.com' or 'molly@my-business-domain.com' Take care not to make a mistake here - or else it will make it difficult for others to reply to your emails. If you do not know what your e-mail address is, you need to contact your Internet Service Provider or Network Administrator. |
EMAIL_SUBJECT |
value |
Specifies the subject for the message. Subject is a text string that identifies the subject for the message. |
EMAIL_CC_LIST |
value |
Specifies the list of e-mail addresses as Carbon Copies to be sent along with the e-mail. |
EMAIL_BCC_LIST |
value |
Specifies the list of e-mail addresses as Blind Carbon Copies to be sent along with the mail. |
EMAIL_DELETE_AFTER_SEND |
ON OFF |
Specifies if the report files are deleted after sending the e-mail. |
EMAIL_SHOW_DIALOG |
ON OFF |
Specifies if the e-mail setup dialog is displayed. The RBTI_PRN_EMAIL_DLG variable will be defined after the dialog is displayed and is set with "OK" when the OK button is selected. Otherwise, it is set as "CANCEL". |
Note: Each additional OPTION parameter must be separated by pipe | character.
Examples:
--Multiple Attachment Example:
PRINT Invoice WHERE TransID = 1031 +
OPTION PDF|FILENAME Invoice_1031.PDF +
|EMAIL ON +
|EMAIL_TO_LIST yourname@yourdomain.com, whoelse@yourdomain.com +
|EMAIL_FROM_NAME John D. Johnson +
|EMAIL_FROM_ADDRESS johndjohnson@yourdomain.com +
|EMAIL_SUBJECT Imagine The Possibilities! +
|EMAIL_BODY Attached is the invoice - sent via R:BASE. Because we Can! +
|EMAIL_ATTACHMENTS C:\Letters\PrivacyPolicy.pdf#C:\Letters\PaymentTermsPolicy.pdf +
|EMAIL_DELETE_AFTER_SEND ON +
|EMAIL_SHOW_DIALOG OFF
--Multi-line Message Body Example:
SET VAR vEMailBody TEXT = +
('Attached please find your sales summary report!'+(CHAR(013))+ +
(CHAR(013))+'Please reply with any questions.')
PRINT InvoiceSummary WHERE CustID = 128 +
OPTION PDF|FILENAME C:\InvoiceSummary_123.PDF +
|EMAIL ON +
|EMAIL_TO_LIST MMurdock@NelsonMurdockLawOffice.com,FNelson@NelsonMurdockLawOffice.com +
|EMAIL_FROM_NAME Wilbur Day +
|EMAIL_FROM_ADDRESS Wilbur.Day@KaxtonLabs.com +
|EMAIL_SUBJECT Invoice Summary As Requested +
|EMAIL_BODY .vEMailBody +
|EMAIL_DELETE_AFTER_SEND ON +
|EMAIL_SHOW_DIALOG OFF