Email Tool for Outlook

[Varshit]

I have an excel sheet where the condition I want to apply is , if the text of a certain cell is "Complete", then send the text of another cell i.e. 1001 complete as the same row as the body of the email. The sender and the receiver details also are available in the same row.

Account	Status	Body of the email	Sender	Receiver
1001	Complete	1001 Complete	Outlook email ID	Outlook email ID

[RolandSchubert]

Hi @Varshit ,

there are two steps to go:

1. Check if condition is fulfilled (i.e., cell contains text "Completed") -> you can use a Filter tool

2. Assign the fields to EMail tool - there is a 1:1 relation between columns in Excel sheet and information to provide to EMail tool.

Hope this is helpful.

Best,

Roland

[binuacs]

@Varshit 

[Varshit]

I get this error saying "Error: Email (16): Record#1: Unable to send email: "Error with FROM: 451 5.7.3 STARTTLS is required to send mail [CY5PR03CA0003.namprd03.prod.outlook.com]
"
Thanks for the reply , Highly appreciated !!!

[binuacs]

@Varshit please share your email configuration also refer the link https://help.alteryx.com/20214/designer/email-tool