Email output

[aparna0208]

Hi,

Earlier I have used the email tool to output an attachment like .csv, .xlsx files. Now I am trying to embed the output directly into the body of the email. For example my output includes customer info  with 8 columns and want to insert that into the body of the email. I tried using Table, Layout tool by referring to articles but nothing seems to work and I'm not receiving any email to my inbox. Wanted to see if there is a way to do this instead of using an attachment? Thank you in advance

[abacon]

@aparna0208 Can you post your workflow? It will be easier to see what's different about the 2 and then go from there. If @jrlindem's workflow works but the main one doesn't, I feel like there is some small difference in the workflow we aren't catching. I could be wrong but that is where my first thought goes.

Bacon

[alexnajm]

@jrlindem & @aparna0208 it worked for me and I received the email! At this point I would check your Email settings...

[jrlindem]

@alexnajm 

The author states that my example does run for them too... but their own workflow does not.  Hoping at mine and @abacon's request the author will post theirs so we can dig in...  Thanks for jumping in though too.  -Jay

[aparna0208]

@jrlindem @jrlindem Attached is my actual workflow

[jrlindem]

@aparna0208 

I just downloaded it, updated the SMTP and TO Email address and ran it....

Given that it's working on my end, I'm not sure how to help.  Your configuration is just fine!  I might recommend that you open a ticket to Alteryx at this point so they can review the logs and see if they can figure out why it won't work on your end.

-Jay

[alexnajm]

Same here @aparna0208 & @jrlindem 

[aparna0208]

@alexnajm @jrlindem Interesting! Probably I'll try to open a ticket and see if I'm able to get any help on this. Thank you so much @jrlindem for patiently looking into this and for all your inputs and help:)

[aparna0208]

And also I think I figured out what the issue could be. So in the example I provided I modified the inputs and its all Text inputs. In my actual workflow I have bunch of different inputs like a SQL script, excel file and Alteryx Salesforce connectors. I ran the workflow that I attached here and it worked but when I change my inputs to the actual one then it's not working and I don't receive any email @jrlindem 

[jrlindem]

I really don't feel like any of that should matter... unless there's some underlying error or warning that's prohibiting the workflow to run to completion.  I would use containers and branches to see if you can isolate portions of the workflow and see if they do/don't initiate the email tool and see if you can narrow it down.  Classic troubleshooting approaches.

Anyway, sorry we couldn't get you there more definitively.  Good luck in your question to figuring it out!  Cheers, -Jay

[aparna0208]

I tried this as well where I broke down my inputs by adding containers and turning it on and off. It's kind of weird where sql scripts and excel sheet inputs work fine but Salesforce connectors are the ones that's causing the issue and I don't get any email when I get that piece to run. I really don't know why connectors are not working but that's the issue here. @jrlindem