Update Excel Status after Sending Email Update

Help Studio
1

Hi

I wanted to update my Excel record after sending Email in every user that dont have status.
if email successfully send i want to update the status to Active

image

Here is the structure of my workflow

image
image585×687 14.3 KB

Reply

2

Hi @Vincent_Nuestro

how u want to update the excel record?

3

@NIVED_NAMBIAR

I want to update per user status after bot sending email.
ex: user 1 send email successful → bot updated the record in excel
after the record updated
Bot must proceed to the next row then send email to the next user and updated the status again.

4

HI @Vincent_Nuestro ,

Please find a sample workflow that hopefully does what you are looking for:

UpdateStatus.zip (10.0 KB)

Thanks & Regards,
Nithin

5

hi sir, @Nithin_P Good day,

Can i have the screenshot of the workflow? i cant open the your file sir.
image

6

Hi @Vincent_Nuestro,

Ensure that you download the image and then view it this gives you better image resolution.

image
image759×1413 89.4 KB

Hope that Helps !

Thanks & Regards,
Nithin

7

I have some project regarding mail after sending mail it will say update mail I get help By @NIVED_NAMBIAR
follow this below screenshoots

you will get op defiantly

Step one read the data from the excel let the variable name is DTOp

then use for each

inside give condition or you can filter use LINQ Code

image
image769×138 2.43 KB

image

image

Hear Index is for each loop inside the for each loop you have to create a variable

image

Regards
Chethan P