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
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
I dont think that works else i dont understand your answer
Can you try as mentioned and let me know what error you are getting
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
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
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
erm i got an error… i got try CurrentRow(0).ToString = “Management email” too but cannot
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 my mistake it works now but can i ask if i wan to attach different files for each email how do i do it?
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
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.