I have a workbench that checks expiration dates in a table and notifies the subscriber if something is expiring in the next week. I writes to an Excel file whether there are results or not and attaches the Excel file and emails the subscriber. This is running in FME Server and works fine like it is. My client would like to only receive an email if something is expiring, and then would like the information in the email body, not as an attachment. How would I do this.
Page 1 / 1
You can e.g. use an Aggregator to concatenate all the rows sent to Excel into a single text block, e.g. using a newline as the separator. You can then use the resulting text block as (part of) the email body.