Generate email with database data

This section will show how to automate the creation of an email with database data.

1. Set up a database connection as described in the previous section of the guide: Set up a database connection
2. In the main window click the '+' button:
3. In the new task window click the '+' button under the 'Actions' tab:
4. In the new action window click the top dropdown and select 'Send email with files, images or database data':
5. Fill out the details of the email until you would need to add the data table. Then click the 'Add attachment' button on the right:
6. Select the database data button at the top, the database connection, enter the SQL / query name and then add a tag that is to be used for it in the email body. Finally click the 'Add attachment' button:
7. An entry for the data table will now show up in the attachments list. Now enter the tag to the desired part of the email and finish the text. Once everything done click the 'Add action' button:
8. At the new task window click the 'Add task' button:
9. To create the email on demand click the '►' button.
10. The email is now created:

And that's it!

For more advanced tasks please see other sections of the how-to guide.

Happy automation!

Download for free