Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here
SOLVED

Email Output Error - Need Help Please

Highlighted
7 - Meteor

Hello I'm trying to run this email output but it is giving me the error message of (Record #1: Error opening file: C:/Users/s0s05v7. Could someone please help advise me on what the issue is here?

 

sky007_0-1579530559055.png

sky007_1-1579530613987.png

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hello @sky007,

 

Could you share with us a screenshot showing the data input (on the results window and the email configuration settings?

 

What I can see is telling me that you are trying to access a file (on relative) to a folder called staging but you are accessing it from the temp path (due the workflow not being saved)

 

Regards

Highlighted
7 - Meteor

sky007_0-1579535202036.png

I saved the workflow and tried running it and it still gave me the same error.

sky007_1-1579535249956.png

Highlighted
7 - Meteor

Forgot to share this.

sky007_0-1579535332632.png

Highlighted
10 - Fireball

The Problem is in the "Email" Configuration window there is no file created so there should be no “Attachments”.

 

But in the “Body” pick “Use Field” and select the field created in the previous “Table(77)” tool and then the table will be created inside the Email Body.

Highlighted
7 - Meteor

So that worked but I want it to be sent where you can open it and then filter down to specific records.

Highlighted
10 - Fireball

Here is how to use a "Render" tool to write the data to a file, attach it to the Email and create a Nice Email Body with the "Report Text" tool.

 

Email with Atttached Setup.jpg

Highlighted
7 - Meteor

Thank you so much, I've never used the render tool but I'm glad I can use it now!! This worked and solved all my issues!

Labels