Sending outlook mail to multiple people from Datatable

Help Activities
, , , , ,
1

Hi All,

I am working on a problem where i have scraped a table from web and stored as Datatable and one of the columns of the Datatable have email id’s like below

Uipath

Now i want to send a mail to all the people in the Datatable in one go, How could i do that using the send outlook mail messages activity.

Thanks

2

Have you tried placing the email addresses in the TO field, separated by “;” ?
image

So basically you should loop through your datatable, take the Email addresses, add them in a string with the “;” as a separator and send that string variable in the To field of the Send Outlook Mail Message activity.

Hope this helps.

4

Maybe there’s a nicer way to do it, but a simple flow could be(it works for me):

image
image444×534 10.6 KB

The value in the assign is: str_EmailAddresses+row(0).ToString+“;”

From what I can see you are sending the email inside the loop which I don’t think is a best practice. If you create the string of addresses in the loop then you can send just one mail and that is it.

Hope it helps.

6

@shekhawat.arjun1307 - The easiest way send an email to everyone in single shot. Just I have concatenate all email together in single variable.

EmailIdMerge.xaml (7.2 KB)

image
image757×367 10.7 KB

Happy Learning :slightly_smiling_face:

7

Hi @saijagadesh06
I am trying the same approach but right now i am getting some issue in send outlook mail message activity, if you could help me with that.

8

@shekhawat.arjun1307 - Just follow my workflow, you should not get any error.

EmailIdMerge.xaml (8.0 KB)

image
image1019×760 22.6 KB

Happy Learning :slightly_smiling_face:

9

Have you try to send just a simple email to just one email address? The timeout might be a connectivity issue.