How do i send email for each approved status?

Help Studio
1

Hi guys, im not sure how do i send each different emails for each approved status in my excel file. I have tried using for each but it will send the emails twice for each approved one. Is there other method to do?

Attached picture is to reference my problem

image
image1920Ă—1032 92.6 KB

image
image1239Ă—798 35 KB

image
image1219Ă—656 26.7 KB

image
image374Ă—855 25.3 KB

2

@SIM_BERTRAM

Try as below

Use Read Range activity and declare a variable for the Datatable Let’s say it as dtData

Now use Filter Datatable and write as “YTD Status” = “Approved”
Input-> dtData, Output->dtData

Now use For Each row activity and pass the dtData

Now place the Send outlook activity and in To you can write as CurrentRow(“Management Email”).ToString

Hope this will help you

Thanks

3

I dont think that works else i dont understand your answer

4

@SIM_BERTRAM

Can you try as mentioned and let me know what error you are getting

Thanks

5

I dont understand ur last part where do i put this → Now place the Send outlook activity and in To you can write as CurrentRow(“Management Email”).ToString

image
image1227Ă—764 27.1 KB

image
image1207Ă—771 24 KB

6

@SIM_BERTRAM

In the place “To” because you need to send to that email address which it is showing in the column “Managment Email”

I believe you got that

Thanks

7

@SIM_BERTRAM

As the previous workflow screenshot, I see you placed the If condition

I didn’t say any If condition so you can remove that

Already we are filtering using the Filter Data Table activity

Again you don’t need filter

Just place the Send Exchange message as below

image

Thanks

8

image

erm i got an error… i got try CurrentRow(0).ToString = “Management email” too but cannot

9

@SIM_BERTRAM

It’s the issue with the Add Server Address of the Exchange Mail Message

Instead of Exchange Mail activity can you use Outlook Mail Message? which you used previously?

Also there is no need of IF activity inside that

Thanks

10

Thanks my mistake it works now but can i ask if i wan to attach different files for each email how do i do it?

11

@SIM_BERTRAM

Glad that worked for you

Can you please close this thread by click on the post as Mark as solution and open a new thread

It’s not a good way to merge all the questions into one post

Hope you understand

Thanks

12

np thkss very much!!

1 Like
13

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.