Sending Automated Emails
- S'abonner au fil RSS
- Marquer le sujet comme nouveau
- Marquer le sujet comme lu
- Placer ce Sujet en tête de liste pour l'utilisateur actuel
- Marquer
- S'abonner
- Sourdine
- Page imprimable
- Marquer comme nouveau
- Marquer
- S'abonner
- Sourdine
- S'abonner au fil RSS
- Surligner
- Imprimer
- Signaler au modérateur
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.
Résolu ! Accéder à la solution.
- Étiquettes:
- Workflow
- Marquer comme nouveau
- Marquer
- S'abonner
- Sourdine
- S'abonner au fil RSS
- Surligner
- Imprimer
- Signaler au modérateur
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).
- Marquer comme nouveau
- Marquer
- S'abonner
- Sourdine
- S'abonner au fil RSS
- Surligner
- Imprimer
- Signaler au modérateur
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
- Marquer comme nouveau
- Marquer
- S'abonner
- Sourdine
- S'abonner au fil RSS
- Surligner
- Imprimer
- Signaler au modérateur
Thank you.
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.
- Marquer comme nouveau
- Marquer
- S'abonner
- Sourdine
- S'abonner au fil RSS
- Surligner
- Imprimer
- Signaler au modérateur
@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
- Marquer comme nouveau
- Marquer
- S'abonner
- Sourdine
- S'abonner au fil RSS
- Surligner
- Imprimer
- Signaler au modérateur
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.
- Marquer comme nouveau
- Marquer
- S'abonner
- Sourdine
- S'abonner au fil RSS
- Surligner
- Imprimer
- Signaler au modérateur
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?
Thank you.
- Marquer comme nouveau
- Marquer
- S'abonner
- Sourdine
- S'abonner au fil RSS
- Surligner
- Imprimer
- Signaler au modérateur
- Marquer comme nouveau
- Marquer
- S'abonner
- Sourdine
- S'abonner au fil RSS
- Surligner
- Imprimer
- Signaler au modérateur
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.
- Marquer comme nouveau
- Marquer
- S'abonner
- Sourdine
- S'abonner au fil RSS
- Surligner
- Imprimer
- Signaler au modérateur
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: