**YouTube** is an American [online video-sharing](https://en.wikipedia.org/wiki/Video_hosting_service "Video hosting service") [platform](https://en.wikipedia.org/wiki/Web_platform "Web platform") headquartered in [San Bruno, California](https://en.wikipedia.org/wiki/San_Bruno,_California "San Bruno, California")

cf3f59da-c081-4fab-99d2-f02e60e183b0.PNG

90f31977-f491-4aca-9187-6c27face5e0e.zip

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.

**Prerequisite**

Relevant version of UiPath Studio installed

Relevant version of all dependency libraries installed using Package Manager

Relevant 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 mails

MS Office Excel application should be installed in the machine where the BOT executes

**Use case**

Read configuration details of sender along with the Subject of the email, Timeout for Outlook, Days between follow ups, Status that is to be updated

Read configuration details of the list of email ids, name, Role and Company to whom the emails will be sent

Checks Inbox for a response from the list of emails ids specified in the configuration sheet

Checks the sent Items for any last sent mail

If 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 email

Maximum of three follow ups are sent

Updates the status of process execution for each mail id in the configuration

Updates status for email ids when: New Mail is sent, Follow Up sent – One, Two or Three, Response Received and Maximum Follow Ups sent

**How to use this component**

Provide 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.

**NOTE**

Content specified in the email is parameterized and takes the Name, Role and Company mentioned in the Configuration file – ‘To\_Details’ sheet

In case of time out, increase the value ‘TimeOutToCheckMails’ in the configuration file

Allows to send three follow mails

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

81a39a2f-0957-43ce-9bd1-f011b57a090f.jfif

eada7946-2d8f-48d3-be3b-8ed05e77f36f.jfif

8eda92b8-e6a6-4073-98b5-363f4004b625.jfif

0057b98f-a0a6-4d6c-8848-8fcd89142e54.jfif

c7e46ab8-74eb-448e-b675-f4ea9c175b9a.jfif

fab8d7cc-7ed5-4db6-b190-2842bde75d30.jfif

c5d2a163-59f2-43d0-b662-2c2925d0542b.jfif

edb18b63-6631-40a6-8262-be9137b414b7.jfif

fe94cb19-25bd-4fb9-961b-5d256e361cc5.jfif

a034e534-10c1-41e6-92a0-b58b18b1fcb8.jfif

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.

Version	Release Date	Download Link
1.0.0.0	February 1, 2019
First release for Send Emails and Follow-Ups automatically to a large group from configured local Outlook

Changepond – Automatic Mass Mailing and Follow-Up