From version 3.0.2095 we have built a connector that enables you to include a dataset as an email attachment (CSV, Excel, XML and JSON) and also provide a HTML table of the data in the email body.
This connector supports connecting to exchange via OAuth and SMTP. You can find it in the connection window under Microsoft Exchange Server > Email Dataset.
The overview of connection process is:
Once you have saved the base connection to your email server you can use the quick create option to populate the properties based upon the source columns added to the schema map. You can read more on how to use this here.