How to send mails from the multiple worksheets of excel file?

Learn
, , , , , , ,
1

Hi all,
I want to send mails to the one mail address form a excel file. but, that excel file has multiple worksheets (In my case, my excel file has 6 worksheet) and I want to send the all data available in that worksheets.

2

@harshdeep007

Can you share me a sample file

Thanks

3

Hello, i am not the same person but i have same issue. Do you want to take a look?

4

Hello @_Thwin_Aung_Aung

Welcome to forums,

For this issue, you can use excel application scope, Get Worksheets activity to get all the sheet names

Use for each loop and place a Read Range activity to read the data present in the sheet

Use For Each row activity and place send outlook / Smtp mail activity to send the mails

Hope this helps you

Thanks

5

Thanks for advice Ksrinu,
My project is that i have an excel file for students and their assigned internship companies. for me, i have already separated these companies into new sheets( according to company). Then i have to send emails to one email address that who the assigned students are . I know there is an activity called “Send Outlook Message”, but i don’t know how to send one email per sheet.
Example - i have sheets for company A, company B and company C, and i have to send three separate emails( one to Company A, another one for Company B, another one for Company C) for three different sheets. I don’t know how to do that.
That is my problem.
Since i am the new comer, forum doesn’t allow me to attach my workflow unfortunately. Sorry about that.