Hi:
Has anyone been able to place the report output into the body of the email message sent out by CE? Here is what I want to do:
1. Using CE 9.0, schedule a report to run daily that looks for records that require attention by our external partners. These records will be identified by a certain value in a certain field.
2. If no records require attention, the process stops and no further action is taken.
3. If there are records that require attention, generate an SMTP email message that states "...there are X records for your attention." where x is the summary count value generated by the report. This will be in the text of the message, not an attachment.
Can this be done?
Thanks.
Has anyone been able to place the report output into the body of the email message sent out by CE? Here is what I want to do:
1. Using CE 9.0, schedule a report to run daily that looks for records that require attention by our external partners. These records will be identified by a certain value in a certain field.
2. If no records require attention, the process stops and no further action is taken.
3. If there are records that require attention, generate an SMTP email message that states "...there are X records for your attention." where x is the summary count value generated by the report. This will be in the text of the message, not an attachment.
Can this be done?
Thanks.