Hello,
I have in total 13 users which needs to be informed once the project is live.
How can i do that so that i can keep on changing the users as per my need from any excel file which has list of users which is being updated on monthly basis.
ok you have to use Read Excel file activity.
Iterate each line from excel by using by using For Each Excel Sheet activity.
read each line item and process send email activity.
this is at a high level.
1 Like
If you don’t want to keep these people list in Config, you can keep your email id on SharePoint or SharedDrive where bot would have access.
You can read this file through bot and pass it to your email sending activity.
This approach will be more practical than Config file maintenance and redeployment in case of any changes.
Thanks,
Ashok 
1 Like
Just put the list of email addresses in the To field. You don’t need to loop and send a bunch of individual emails. One email can have multiple recipients.
@Vivek_Pandey2 just put the email address in a list in the config file:
email1@somewhere.com,email2@somewhere.com,email3@somewhere.com
That’s for Send SMTP Email. I think if you’re using Outlook the separator will be semicolon (
1 Like
Well, that is not what @Vivek_Pandey2 is looking.
He has multiple set of emails with different content of subject and body.
He wanted to loop them with and send separate content and subject for each email separately.
this solution would be useful please check
That’s not what it says.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.