I am trying to email an execution report which is generated via Automation Policy; I get the policy via email in HTML format even I choose it as .csv format. I would like that report to be email to me as an attachment in .csv format.
Any suggestions / guidance is most welcome
Unfortunatly attaching a file via email using an automation policy is not possible. In cases where I needed to do this, I created the report in SQL report manager and setup an email subscription.
Note: if you want this ability in a future release, go to this "idea" and vote for it
Here is the KB acknowledging the limitation:
Here are instructions for setting up a subscription for an ITA report which does support attachments in various formats: