Scheduled Email based on Condition

[Sirfyaad]

I have to send data every week, to many people. But everyone has to send data according to them. Below I have given an example.

COURIER NAME	EMAIL
AMAZON	RAHUKH@GMAIL.COM
BLUE DART	YUIHIH@GMAIL.COM
DELHIVERY	SAIF455@HOTMAIL.COM
DELHIVERY 15KG	YASIF4555@GMAIL.COM
ECOM EXPRESS	RAHUKH@GMAIL.COM
EKART LOGISTICS	YASIF4555@GMAIL.COM
MYNTRA	YUIHIH@GMAIL.COM
SHADOWFAX	RAHUKH@GMAIL.COM
UNIMOVE ( SNAPDEAL )	YASIF4555@GMAIL.COM
XPRESSBEES	SAIF455@HOTMAIL.COM

my data table

I have to send the details of a week to everyone according to the column [Courier Name]. Can you tell me how can I send with the help of auto bot.

[WillowMobileSys]

Please start by reviewing this document:

Send an Email from automation

You would start by creating a Bot that has Event Type of Schedule,  runs against your Data table, add the frequency you wish to run and a Condition to select the rows you wish to generate and send emails for.

When it comes time to update the "To" property with the email addresses to send the email to, you can use an expression to retrieve the email address.  It would be something like:

ANY(SELECT(Courier[Email], [Courier Name] = [_THISROW].[Courier Name]))

[Sirfyaad]

ANY(SELECT(Auto bot Email[EMAIL], [CHANNEL] = [_THISROW].[CHANNEL]))

The expression is valid but its result type 'Email' is not one of the expected types: Yes/No

[WillowMobileSys]

Please show as screenshot of the entire Expression Assistant window for better clarity on what the problem is.