Hi All,
I was wondering if I can send out a table through email using Alteryx?
Please see the attached workflow.
Appreciate your help.
Hi there,
I have uploaded a workflow that has added what I think you mean. You need to add a table tool before the email tool, otherwise it will send one email for each row of data, I also changed the data types so they are in the right format for the output.
Alex
Yes you can just put an email tool after and configure appropriately (Set Body to equal Field Table). Note you will be sending 3 emails as you have 3 separate tables.
Hi Ryan,
I noticed that you can only choose one field at a time while configuring email. Can you send both of the fields in one email (as shown in the following table)?
I made some changes to the workflow, please see the attached.
Thank you so much.
Any resolutions on this?
Create the body of the e-mail in Report Text tool and put that in your e-mail. Make sure you've added the table in report text.
I am not sure, is this what you are trying to explain ? attached image.
when I am checking in Browse Tool , it looks corrupted as per attachment, Thanks in advance!
do you have attach to existing field toggled in report test? if so you attach to your text.
I tried that, still not working, can we save email as draft without sending it. with table and dynamic email body.
I was able to follow @phoebe_kelley suggestion above and that works for me.
I am on Designer version 2021.4.2.05617
Looking at the image @Paresh1pandya posted earlier, the table is technically being listed twice. What this tool does is add the information in the "Text Data" field to each "Table" field in the results. What you do not want to do is list the table in the "Text Data" configuration as that is what inserts the HTML view of the table. So by removing the [Table:A] will solve this issue. Your email tool would need to point to the Table column for the body.
Picture of your configuration:
Here is a sample of what mine looks like (I have the individual country name listed in the "Sheet Name" column so I can use that in the email body as well):
Then my email tool just references this newly created table:
