Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Announcement | We'll be doing maintenance between 2-3 hours, which may impact your experience. Thanks for your patience as we work on improving the community!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Email Output Error - Need Help Please

sky007
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

8 REPLIES 8
afv2688
16 - Nebula
16 - Nebula

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

sky007
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

sky007
7 - Meteor

Forgot to share this.

sky007_0-1579535332632.png

darryl5280
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.

sky007
7 - Meteor

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

darryl5280
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

sky007
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!

balubindass
5 - Atom

I learnt new way to do. Actually i was facing issue while running my workflow on gallery and your post is the solution. Thanks

Labels