I want to make a bot which will send email

Hey Friends, need your help again.

I have one excel file, in 1 column we have an app code like HPALM and JIRA and in the 2nd column we have email id corresponding to the first column.

I want to make a BOT which will send an email to the email id corresponding to the app code in front of it.

For example, kindly refer below.

for HPALM it should send an email to karanvirsingh@abc.com
for JIRA it should send an email to john@abc.com

Any help will be appreciated.

image

the app code and email ids will always be different.

@karan_singh2a you can do it using For Each loop. See this example

The logic is the same as in your use case.

Noted with Thanks,

Let me try ,

Mean while i am using this script which i made yesterday.

1 Like