The process sends new mail or follow up mails to a list of users from the locally configured Outlook. It allows sending a maximum of three follow up mails. In case of a follow up mail, the new mail is sent on top of the last sent mail to the user. When a response is received, the status is updated and sending follow ups are ignored. The process sends the follow up emails in a pre-configured time span. The content is formatted and the same is preserved throughout the follow ups sent. Description for each configuration is detailed in the description column of the ‘eMailListConfig.xlsx’ file.PrerequisiteRelevant version of UiPath Studio installedRelevant version of all dependency libraries installed using Package ManagerRelevant configurations provided in ' eMailListConfig.xlsx' and mail contents are provided in the files 'EmailContent.txt', ‘FollowUp_1.txt’, ‘FollowUp_2.txt’, ‘FollowUp_3.txt’MS Outlook should be configured in the local system (where BOT executes) with the email id used to send mailsMS Office Excel application should be installed in the machine where the BOT executesUse caseRead configuration details of sender along with the Subject of the email, Timeout for Outlook, Days between follow ups, Status that is to be updatedRead configuration details of the list of email ids, name, Role and Company to whom the emails will be sentChecks Inbox for a response from the list of emails ids specified in the configuration sheetChecks the sent Items for any last sent mailIf there are no mails sent to the email id a fresh mail is sent with the content specified in 'EmailContent.txt'Depending on the count of mails sent, the BOT sends the next follow up on top of the last sent emailMaximum of three follow ups are sentUpdates the status of process execution for each mail id in the configurationUpdates status for email ids when: New Mail is sent, Follow Up sent – One, Two or Three, Response Received and Maximum Follow Ups sentHow to use this componentProvide configuration details available in Configuration\eMailListConfig.xlsx.Provide relevant details in 'From_Details' worksheet.Provide relevant details in 'To_Details' worksheet. DO NOT enter anything in ‘Mail_Sent_Status’ column.Emails will be received by the IDs mentioned in To List. And in emails mentioned in From List, 'Sent Items' will show emails sent.NOTEContent specified in the email is parameterized and takes the Name, Role and Company mentioned in the Configuration file – ‘To_Details’ sheetIn case of time out, increase the value ‘TimeOutToCheckMails’ in the configuration fileAllows to send three follow mails

Send Emails and Follow-Ups automatically to a large group from configured local Outlook

MIT License Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the 'Software'), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions: The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED 'AS IS', WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.

Senior Software Engineer

Hi Ponmani,This is very useful component. Can you please give enhancement on your component for more than 3 follow ups? Regards,Nirmal desai

How we can trigger automation using Orchestrator Queue? What changes we need to make in our project? Could you please explain this problem?

Changepond – Automatic Mass Mailing and Follow-Up

Changepond – Automatic Mass Mailing and Follow-Up

Help

How To