Include Output Log in Email Tool

[zqlcancer]

The 'Send Email' function which can be triggered in Event includes lots of useful information like number of errors and log details. Is it possible we can include such information in an email tool?

[rzdodson]

@zqlcancer there definitely is, but it isn't pretty. :)

First, run your workflow to get the initial output log. What helps here is creating a dummy output file coming out of the first anchor of a Block Until Done tool. This will ensure that an output (and the Output log) is generated before we start working with the email section of the workflow. From here, you are going to want to right click on any message in your Output log. It is going to give you an option to "Save As". This should be your entire output log. Save that file as a text file.

Second, create the remaining elements of your workflow. Once you get to your email tool, change the "Attachments" settings to retrieve that text file you just saved. This will add the Output log as an attachment to the email you are constructing in your workflow. If you are wanting the Output log to appear in the email body itself, I would recommend putting it in a macro so you can retrieve the file's contents. At that point, it'll become a string field that you can then use to inject in to the body of your email.