Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
I've created a workflow which creates, executes and then deletes a Visual Basic Script file. The VBS file contains a script which interacts with Outlook, creating a new email and displaying it, this can also be changed to simply send the email, notes inside the workflow. Important: Upon the completion of the workflow (file is written) there is an event which is triggered that executes the file using cscript.exe. The next step is to add an attachment to it. Feel free to contact me in case of questions/improvement suggestions.
@MiroslavJ Let me know if you need further assistance in testing and thank you @ChrisTX maybe it's a good idea to add some details in the post instead of the workflow:
The Code that will be executed in the command tool begins as
Dim objOutlook, objMail
Set objOutlook = CreateObject("Outlook.Application")
Set objMail = objOutlook.CreateItem(0)
objMail.Subject = "<subject>"
objMail.Body = "<body>"
objMail.Recipients.Add "aimb3@example.com"
objMail.Display
Set objMail = Nothing
Set objOutlook = Nothing
Then the parameters between the "<>" are replaced and the result is written to a .vbs file for convenience, but that step can be skipped as the Run Command Tool can write its own .vbs files, following configuration :
As well as the "Write Source" config:
Let me know if you need further assistance.
Hi all, I'll reupload the workflow from the newest Alteryx Version and without the control container just to be sure:
