Enabling Emailer Comments etc

From an email exchange with Imelda 19 May 2016

Keywords : Emailer Comment, Report Name in Subject Line, Enable / Disable Email Feature

In Emailing reports

1 when reports are emailed, is it possible to get the report name (used in the subject line) as the file name for the attachment.
2 is it also possible to add in a comments section so that when a scheduled or non scheduled report is emailed a comment or explanation can be added to the email rather than please see the attached PDF? I email reports to people but can't explain to them what I'm sending.

>> Imelda :

Yes both requests are available.

Use the command –reportname in the emailer to call the file after the report name e.g. Emailer.exe –reportname
To customise the email body message do the following:
1. In Utilities_Boolean.asp set EnableEmailExtraDesc to true
2. In the system33 database, ensure there is a memo (long text) field called extra_desc in the UserReports table.

Onces these are set, in IR when saving or modifying a report, you will see a new input field Email Text. Text entered here will appear in the email body. Please note that this input box will only be available for .xls/.pdf/.csv reports. HTML reports are already embedded in the email body, so can’t be used.

Also on Email_Now()

Sure, if you want to use the Email Now function (assuming that you have the EmailReports table), then you also need the memo (long text) field called extra_desc

And a request for restricting email support with John Sullivan (23may16)

You will need to update the users table in the IR System database to add a field called

deny_emailer of type integer

value = 0 means user can send email

value = 1 means user cannot send emailer

And update your systems to maintain that field

We can then make a change to IR to modify the allowEmailer() function to pay attention to that.