Hi,
I'm working on a project where i need to send Emails of Employee details to their respective managers , Is there a way I can do this.
Please help me with this .
Thank you.
Please try a fixed file path rather than the temp. No issues with a fixed path but every time I run it using the [Engine.TempFilePath], I get the same error. This way I will always have a copy of the file in the static path if I ever need it.
The error is due to the Render Tool's Output Mode set to specific file path rather than the Tempory path. Even if I change the Render tool to a Temporary path and update the formula to only reference [Engine.TempFilePath], I get an Access is Denied error. This reminded me of why I always do a fixed path.
Hi @nkrupabd,
Yes this is definitely possible. You'll want to check out the reporting tools to accomplish this. This will allow you to dynamically create the content (body, to, subject, etc).
Hey @nkrupabd,
Like @Luke_C says Alteryx has an email Tool which can be fully Automated to send to a list of people from your data:
Also if you want to schedule the email that is also possible check out this thread: Solved: Email Tool - Alteryx Community.
Any questions or issues please ask HTH!Ira
The issue here is How do i attach the data of particular Manager (separate Sheet for each manager ) to the Email sent to that Manager.
@nkrupabd To achieve this I would use a batch macro which would loop through each manager and filter on just the data needed for them before sending out an email. The community has some super quick videos on how this works here: Interactive-Lessons Macros
Here's a simple email macro based on data input depending on if you are looking for a mass emailing.
The workflow has an input file of Employee, Manager, and Manager's email. Then a formula with a single Email Subject that is to be used on each email; this could be customized per email if needed.
The macro is then fed the input file and the email body is constructed based on individual Employee and Manager names; this is a single template to be used on each email. Then the email tool sends the email.
You will need to update the Email tool info with your Email SMTP and From Email address. (also will need to make sure the input tool has valid email addresses) You can simply update all email addresses to your own for testing.
Hopefully this helps as a starting point.
Thank you for the solutions.
This will work in case we have a single output,
But I have like 150 managers and under each manager there might be some where around 30 employees.
For each Manager we will be having an excel output with all the employees under him and this excel output should be send as an attachment in the Email to that particular manager.
Is this possible?
Here's a simpler workflow without the macro. Again, update the input file with valid email address(s), the report formula with correct file path, and the SMTP/From email info in the email tool.
Thank you I used this but I'm getting an error,
Email (31) Record#1: Error Opening file: C:\Users\nkrupabd\AppData\Local\Temp\Engine_15876_14193a038bae4f2eb304932df72e81e7_\Report.xlsx: The system cannot find the file specified.
Is this error message based on the example workflow I provided or your own workflow? Your error message indicates the report file name is not unique/specific as it's just '...\Report.xlsx'.
The workflow example I provided will create unique reports based on the manager such as '...\Jim_Employee_report.xlsx' or '...\Mary_Employee_Report.xlsx', etc.
So the Render Tool output file name (and path) must be the same as the formula tool. So for me, my workflow is stored on my OneDrive thus the Render tool will save the output file to the same OneDrive location. Then my formula tool is based on the OneDrive path.
If your workflow is stored at AppData path as in the error message, 'C:\Users\nkrupabd\AppData\Local\Temp\Engine_15876_14193a038bae4f2eb304932df72e81e7_\', then your formula would look like this:
It is able to open the first ID details and if u see the error it is not able to open the second ID
Email (31) Record#1: Error Opening file: C:\Users\nkrupabd\AppData\Local\Temp\Engine_12608_592cf7f0820744cfa0c5122dd12abf09_\12345678_Employee_Report.xlsx: The system cannot find the file specified. (2)
Can you attach your workflow with sensitive data redacted? Does the example workflow I sent work without errors after updating the Email and file path info?
I'm attaching a screen shot as it contains sensitive data i cannot share the workflow
Thank you, I used the fixed path and unfortunately it is still throwing the same error.
Back to my question, does the example workflow I supplied work when you update the email addresses, fixed file path, Email SMTP, etc?
Thanks a lot , it worked . Really appreciate the quick response.
@nkrupabd No problem, glad it's finally working for you. Please remember to mark appropriate working response as a solution.
@nkrupabd - Here's an updated version using the temp file rather than a fixed file path if you need it.
