In this&nbsp;technologically advanced world, emails are the fastest and easiest written ways of communication. Exchanging and downloading numerous emails attachments can be a tedious manual task for the receiver.With this snippet one need not traverse through all emails and download manually. This processor will download attachments in a structured manner.Email Attachment Processor is a Library which would help one eradicate manual work and save time by downloading all attachments in a structured format.Protocols / Methodologies supported:<ul><li>POP3</li><li>IMAP</li><li>Outlook·&nbsp;&nbsp;</li></ul>Usecase:1.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Read emails from the email account provided in configuration2.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Process each emails and check for existence of any attachments3.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;In case of attachments, the extension of each attachment is identified4.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Identified extensions and their files are downloaded in below structured format to a output path indicated in configuration

Automatic processing of email attachments.

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.

Technical Architect - RPA

 - Hello Jai,
This is a very good automation idea, however there are several improvements that are necessary in order to be as useful as it is interesting.
Observations:
* nested “IF” activities should not be used (you are using at one time 7 nested IF activities instead of one switch activity for example)
* you should add a sequence inside another sequence only when delimiting a block or something. You had a double sequence without any obvious reason
* use suggestive names for your workflows and folder structure inside your project
* add annotations for the users to understand what you are trying to do with the activities
* change the activities naming for a clear understanding of your workflow (also easy to follow if some errors occur)
* please read the best practices (https://docs.uipath.com/studio/docs/design-best-practices)
Thank you


The Master data creator snippet enables the creation of master data in QuickOooksOnline (QBO) accounting software. Using it you will be able to automatically create New Vendor entries in QBO by inputting the following details in two separate sheets:In the "Quickbooks Account Details" sheet add the:<ul><li>QBO CompanyID(Realm ID),</li><li>Access token</li><li>EndpointURL</li></ul>In the “New Vendor" sheet, add the vendor details.

Automatically create New Vendor entry in QuickBooks from an existing spreadsheet

Software Engineer

Mass emailing - sending emails in bulk to large groups of people is a tedious and time consuming process when done manually. Most of the individuals or organizations rely on third party providers paying huge amounts to publish email content to larger groups.Mass mailing snippet provides an easier way to handle bulk email. It's just the configuration one needs to provide correctly. The rest will be handled by Bot where bulk emails are sent in fraction of time.Prerequisite:<ol><li>Relevant version of UiPath Studio installed.</li><li>Relevant version of all dependency libraries installed using Package Manager.</li><li>Relevant configurations provided in 'eMailListConfig.xlsx' and 'eMailContentConfig.txt'. Description for each configuration is detailed in configuration.</li><li>MS Office Excel application should be installed in the machine where the Bot executes.</li></ol>Use case:<ol><li>Read configuration details of who will be sending the email</li><li>Read configuration details of which Server and Port email will be triggered from</li><li>Read configuration details of the list of items to which emails will be sent</li><li>Read configuration details of the email content that should be sent to the intended email list</li><li>Bot executes, gather From, To, SMTP relay details and email Contents. Iterates and sends email to all IDs in the list.</li></ol>NOTE: If one sees Sent Items mail box of the sender, details of whom sends the email will be displayed.How to use this component:<ol><li>Provide configuration details available in Configuration\eMailListConfig.xlsx.</li><li>Provide relevant details in 'From_Details' worksheet.</li><li>Provide relevant details in 'To_Details' worksheet.</li><li>'Server&amp;Port Details' worksheet is for your reference as what server and port details to provide.</li><li>Provide relevant email content in Configuration\eMailContentConfig.txt. Do not change {0} in first line and {1} in last line which are placeholders and values will be binded from config.</li><li>Open Mass Mailing application in UiPath and execute.</li><li>Emails will be received by the IDs mentioned in To List. And in emails mentioned in From List, 'Sent Items' will show emails sent.</li></ol>

Email content automatically to a large group by using Bot, thus avoiding manual intervention and monitoring

 - Although it looks more like a solution than a snippet, it works fine and can really make things easier when sending emails to many people.
My only concern is regarding security, since the password should be written in the Excel configuration file. One alternative would be to receive the password as an argument, so users could pass them during execution (via Request Credential activity or Input Dialog activity) or fetch credentials from Orchestrator.
Good job with the component!


Automatic Outlook Mailbox Creator creates new mailbox folders and moves emails from a specific sender. If the mailbox specified already exists, an alert will be shown whether to use the existing mailbox or user can opt to create a new mailbox. Once the new mailbox is created based on input provided, emails move automatically to this folder.Simple Use case<ol><li>Select small or group of emails (bulk) to move from one folder to another.</li><li>Indicate source and destination folder.</li><li>Indicate from which email address, emails have to be moved.</li><li>If the destination folder already exists, raise a message to user to use the existing folder or create a new folder.</li><li>Provide date range from when to when emails should be looked upon.</li></ol>Configuration<ol><li>NewFolderName - Name of the mailbox folder where emails will be moved. This can be an existing folder or a new folder.</li><li>EmailID - eMails from this Email ID will be moved from Inbox to folder specified above.</li><li>Top - Number of emails that will be looked upon for movement within given specified date range.</li><li>FromDate - Filter indicating from which date emails have to be looked upon for a match to move. 'dd-MM-yy' format</li><li>ToDate - Filter indicating till which date emails have to be looked upon for a match to move. 'dd-MM-yy' format</li></ol>How to run<ol><li>Provide relevant configuration details in the config spreadsheet.</li><li>Make sure Outlook account is setup in the machine where the bot is executed.</li><li>Execute the Bot.</li><li>Check whether Mailbox folder indicated in the configuration is created.</li><li>Check whether all emails from sender specified in configuration within specified date range are moved to the new Mailbox folder created.</li></ol>NOTE:If you encounter timeout in ‘Get Outlook Mail’ activity, it will be due to Bot working with huge number of emails. In such cases increase ‘TimeOutMS’ property&nbsp;

Microsoft Outlook Mailbox creation and email movement enables to create email folders in Outlook automatically with your choice of name and move intended emails

Senior Software Engineer-RPA

Hello, how&nbsp;to use your tool for creating folder and process mails from other than default mailbox?I have a case with 10 mailboxes and need to create folders/move mails&nbsp;on each.

hello ,the software works fine when i use any email other than gmail, when ever i login into my gmail account and run the software it give me this error(If: Object reference not set to an instance of an object) help me please.

 - This solution (more than a snippet, actually) is easy to use and it works fine with minimum configuration.
The workflows themselves are a bit bloated with extra activities, but nothing that prevents their understanding.
As a suggestion, it could be useful to have the ability to define the source folder from the configuration file as well (not only the destination folder).
Good job!


This bot enables users to create a bundle of vendors in Bill.com accounting software in a quicker and easier manner. It covers all UI inputs of the vendor creation including 'E-Payment' invite by giving its corresponding input details via Excel file. Also it enables users to track its status at the end of the process in the Output report. 

This bot fetches all mandatory information for vendor creation from a spreadsheet and uses Bill.com APIs to login, selecting company, creating vendor etc.

This component helps to create vendors (in bulk) in Bill.com using API calls enabling quicker and faster ways of adding vendors to the bill management software.

Senior Software Engineer

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

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?

About Us

Changepond - Email Attachments Processor…

Changepond - Master Data Creator in Quickbooks…

Changepond - Mass Mailing Component…

Changepond - Automatic Mailbox Creation & Movement…

Changepond - Automate Vendor Creation in Bill.com…

Changepond – Automatic Mass Mailing and Follow-Up…

Help

How To