AN INTERNSHIP REPORT ON

E-MAIL ATTACHMENT AUTOSAVE BOT

submitted by

AVINASH G S (113221041019)
BALASHANMUGAM B (113221041021)
MOHAMMED THOWFIC S (113221041079)

in partial fulfillment for the award of the degree

of

BACHELOR OF ENGINEERING
IN
ELECTRONICS AND COMMUNICATION ENGINEERING

VELAMMAL ENGINEERING COLLEGE, CHENNAI-66.

(An Autonomous Institution, Affiliated to Anna University, Chennai)

2023-2024
 BONAFIDE CERTIFICATE

Certified that this internship report “ E-MAIL ATTACHMENT AUTOSAVE

BOT” is the bonafide work of AVINASH G S (113221041019),

BALASHANMUGAM B (113221041021) and MOHAMMED THOWFIC S

(113221041079) carried out at “EAGLE TECH-IT SOLUTIONS” during

06.12.2023 to 22.12.2023.

SIGNATURE SIGNATURE

ii
iii
iv
v
 CERTIFICATE OF EVALUATION

COLLEGE NAME : VELAMMAL ENGINEERING COLLEGE

BRANCH : ECE
SEMESTER : VI

Name of faculty
Name of the student who
Sl. No Title of the Internship coordinator with
has done the Internship
the designation
1 AVINASH G S
E - MAIL
2 BALASHANMUGAM B ATTACHMENT

MOHAMMED AUTOSAVE BOT

3
THOWFIC S

This report of internship work submitted by the above students in partial

fulfillment for the award of Bachelor of Electronics and Communication
Engineering Degree in Anna University was evaluated and confirmed to be
reports of the work done by the above student and then assessed.

Submitted for Internal Evaluation held on........................

EXAMINER 1 EXAMINER 2 EXAMINER 3

vi
 ABSTRACT

Automatic E-mail attachment saver is a UiPath tool-based bot. This system can be used to

automate the workflow of an employee who needs to download attachments from email and

sort them according to their subject. The project has been planned to reduce the time and

increase the efficiency and productivity of the employees. Using the UiPath tool the software

can be built with ease. A salesperson can download many attachments from the e-mail using a

bot. You need to train a bot to download the attachments. The bot stores the resources inside a

folder automatically without the need of humans based on the subject of resources. This way

the employer and the employee can save time and increase productivity.

vii
 TABLE OF CONTENTS

CHAPTER NO. TITLE PAGE NO.

ABSTRACT vii
LIST OF FIGURES x
LIST OF ABBREVIATIONS xi

1. INTRODUCTION AND COMPANY PROFILE 1

1.1 PURPOSE OF THE PROJECT 1

1.2 ABOUT THE COMPANY 1
1.3 SOLUTIONS AND SERVICES 2
1.4 EVENTS 2

2. PROBLEM STATEMENT 4

2.1 REALITY 4
2.2 CONSEQUENCES 4
2.3 IDEAL SOLUTION 4
2.4 PROPOSAL 4

3. LITERATURE REVIEW 5

3.1 ROBOTIC PROCESS AUTOMATION 5

3.2 UIPATH 7
3.3 ADVANTAGES OF UIPATH 9
3.4 FUTURE SCOPE OF RPA 10

viii
4. RESULT AND DISCUSSION 12

4.1 SEQUENCES 12
4.2 GET IMAP MAIL MESSAGES 13
4.3 THE FOR EACH ACTIVITY 14
4.4 THE IF ACTIVITY 15
4.5 SAVE ATTACHMENTS 16

5. CONCLUSION AND FUTURE WORK 17

5.1 CONCLUSION 17
5.2 FUTURE ENHANCEMENT 17

APPENDIX – I SEQUENCES 18
APPENDIX – II SNAPSHOTS 19

REFERENCES 21

ix
 LIST OF FIGURES

FIG NO. NAME OF THE FIGURE PAGE NO.

1.1 Eagle-Tech IT Solutions logo 2

3.1 Advantages of RPA 6

3.2 Growth of RPA 6

3.3 UiPath Logo 8

3.4 UiPath Growth 8

3.5 Advantages of UiPath 10

3.6 Future Scope of RPA 11

4.1 Sequence 12

4.2 For Each Loop 14

4.3 The If Activity 15

x
 LIST OF ABBREVIATIONS

TERMS ABBREVATION

RPA Robotic Process Automation

UI User Interface

OEM Original Equipment Manufacturer

AR Augmented Reality

VR Virtual Reality

xi
 CHAPTER 1

INTRODUCTION

1.1 PURPOSE OF THE PROJECT

This project is aimed at developing a bot to download the e-mail attachments using the UiPath

tool. Nowadays, people are receiving lots of emails such as documents, PDFs, etc. Instead of

downloading the attachments one by one, we can use a bot to download the various kinds of

documents. It’s the most efficient way so far. We can download any type of file format such as

pdf, jpeg, excel sheet, etc.… using this bot based on the subject of the resource.

1.2 ABOUT THE COMPANY

Eagle-Tech IT Solutions is a Technology Solution Providing firm that has been providing

industry 4.0 solutions and services to many notable organizations since 2016. They specialize in

providing IT-related support services such as Annual Maintenance, Network consulting,

Content Development, etc., and solutions in Artificial Intelligence, Networking, Server,

Storage, etc. Its goal is to give customers freedom and satisfaction by providing the highest

level of service. They are committed to providing cost-efficient and quality service to

customers.

As a Technology Solution Provider, Eagle-Tech IT Solutions builds industry best and latest

technology IT solutions that fit the unique requirements of customers. Representing the most

influential OEMs in the industry, Eagle-Tech IT Solutions rides the cutting edge of the

technology wave. They digitally transform Very Large Enterprise, Small and Medium

Enterprises, Small and Medium Businesses, and start-ups inside out. The solutions we

represent, implement, and support are designed to launch customers from their current state into

1
a more mature IT arena, setting them above the competition. They strive to build quality

solutions that bring efficiency, effectiveness, and return on investments.

Fig 1.1 Eagle-Tech IT Solutions logo

1.3 SOLUTIONS AND SERVICES

They provide Industry 4.0 solutions such as AI, AR/VR, Data Center, Machine learning,

Security, Networking, Server & Storage, Robotic Process Automation, and Deep learning.

Services include Annual Maintenance Contract (AMC), Color Calibration, Data Center,

Infrastructure Management, IT Consulting, Content Development VR/AR/MR, Networking

Consulting, Cyber Security, and Security Auditing. They also use software such as Adobe,

IBM, Microsoft, Oracle, Commvault, VMware, Citrix, Kaspersky, McAfee, etc.

1.4 EVENTS

They also conducted various events with Adobe, EVO, Dell, Oracle, etc. Eagle-Tech IT

Solutions. It was an elaborate explanation of the product and the audience was said to attend the

event. We got a list of positive feedback from the attendees. It was an informative event. The

speakers have skilfully presented “Oracle Database Appliance – The Cloud-ready engineered

system for Business”. They had interactions with the audience about the technical benefit of the

2
spoken product features and its competitive analysis. The audience of the event was happy that

they gained worthy information about the leading products.

ETS is one of the leading bootstrapped pure-play IT Services and Software development

company that are on a mission to provide an industry-leading platform for software

applications. ETS is constantly expanding its family and is looking for dynamic fresher’s and

graduates with a background in Computer Science. Once a part of the family, you can be

confident that your career is in safe hands. ETS has clients all over the world that hands you the

opportunity to work on a variety of projects. If you believe testing to be your forte, then ETS is

one of the best places you could possibly work in.

3
 CHAPTER 2

PROBLEM STATEMENT

2.1 REALITY

A salesperson finds it difficult to download many attachments every 5 minutes. Attachments

such as PDFs, word documents, excel sheets, etc. This is a problem for the company because

they need to track every phone call, a number from the client. We identified this from the

salesperson and proposed a solution for this issue.

2.2 CONSEQUENCES

The company as well as the employees need to spend a lot of time downloading data and

assigning them based on which client it was received and much more. This results in a loss of

productivity and employees sometimes get irritated by the continuous repetitive process which

leads to a loss of peace of mind and time.

2.3 IDEAL SOLUTION

The employer or the employee can have data resources sent by clients kept in an order which

can easily be accessed at any time without losing productivity.

2.4 PROPOSAL

A salesperson can download many attachments from the e-mail using a bot. You need to train a

bot to download the attachments. The bot stores the resources inside a folder automatically

4
without the need of humans based on the subject of resources. This way the employer and the

employee can save time and increase productivity.

CHAPTER 3

LITERATURE REVIEW

3.1 ROBOTIC PROCESS AUTOMATION

Robotic process automation (RPA) is a software technology that makes it easy to build, deploy,

and manage software robots that emulate human actions interacting with digital systems and

software. Just like people, software robots can do things like understanding what’s on a screen,

completing the right keystrokes, navigating systems identifying, and text extracting t a

performing a wide range of defined actions. But software robots can do it faster and more

consistently than people, without the need to get up and stretch or take a coffee break. RPA

technology is changing how the world gets work done. Software robots—instead of people—do

repetitive and lower-value work, like logging into applications and systems, moving files and

folders, extracting, copying, and inserting data, filling in forms, and completing routine

analyses and reports. Advanced robots can even perform cognitive processes, like interpreting

the text, engaging in chats and conversations, understanding unstructured data, and applying

advanced machine learning models to make complex decisions. When robots do these types of

repetitive, high-volume tasks, humans are freed to focus on the things they do best and enjoy

more: innovating, collaborating, creating, and interacting with customers. Enterprises get a

boost too: higher productivity, efficiency, and resilience. It’s no wonder that RPA is rewriting

the story of work.

5
Fig 3.1 Advantages of RPA

Fig 3.2 Growth of RPA

6
3.2 UIPATH

UiPath is a Robotic Process Automation tool that is used for Windows desktop automation. It

is used to automate repetitive/redundant tasks with the help of drag and drop functionality and

eliminates human intervention. This tool offers various editions to support different types of

users and comes with an active community to resolve issues. According to Deloitte’s 2019

Technology Fast 500, UiPath Ranks No. 1 in North America. It is used by multi-national

companies such as AIRBUS, NASA, AUTODESK, DHL, HP, PARADISE, etc.

Being the market leader, it is trying to make sure it caters to all types of audiences whether it be

a fresher, or an experienced professional working in top enterprises by providing various

editions. Any action done by the human user through mouse and keyboard is coded into

activities. Apart from the regular browsing and navigation, there are several logical activities,

system activities, programming activities, and app integration activities that sync with

applications like Excel, CSV, PDF, Databases, and Email. There are more than hundreds of

individual activities that enable the automation of the most complex tasks. User events are for

robots and humans working together. The application waits for a particular action from the user.

When the user acts, the robot gets involved and performs its tasks. The robot can perform

without intervening in any of the user’s actions. For instance, the robot can wait for the user to

click on a specific button. When the user clicks, the robot can scrape the data, perform

calculations on it and send the results back to the human user. To wind up, UiPath Studio is a

proficient, feature-rich IDE (Integrated Development Environment) that allows you to visually

design automation with a drag and drop editor. UiPath provides hundreds of predefined

automation blocks like web scraping. The Recorder feature allows you to capture the steps of a

manual task. During the recording process, all the user actions on the screen are surveyed and

7
are translated into logical steps (workflow). The Screen Scraper Wizard and the Web Scraping

Wizard enables you to derive data from any application.

Fig 3.3 UiPath Logo

Fig 3.4 UiPath Growth

8
3.3 ADVANTAGES OF UIPATH

One of the major concerns for any company is to recognize any compliance issues earlier and

sort them out. Now with the help of this RPA Solution, i.e. UiPath, employees now can run

internal reviews regularly, which allows them to proactively identify and manage any

compliance issues. UiPath utilizes its RPA features to eliminate gaps between different sources

and logs the actions completed by robots as part of process automation. While it speeds up the

back-office tasks with RPA using UiPath, it also allows companies to provide timely and

effective services to their end customers. UiPath with its centralized management server, allows

organizations to deploy and manage bots to perform the activities automatically. It also has a

one-stop place for analytics. The ability to control bots from the central server provides better

security and management capabilities. UiPath has embedded the capability to trigger python

scripts, which means it can even trigger machine learning models, now bringing them into

business process automation leads to different possibilities. Robots can now predict and take

decisions wherever required and bring data science capabilities. In addition, UiPath had

introduced Natural Language Processing (NLP) which will make reading and understanding of

uments/emails more possible. UiPath delivers both the attended and unattended automation in

the enterprise RPA system. You can run an attended robot on your PC, and also decide when to

start it. Unattended automation allows remote system automation even out of sight on a timed

schedule. UiPath provides its users to save their workflow as a template and preserve the

original workflow. It also helps in improving the reusability of the code, which can be used at a

9
later date. UiPath RPA improves cost and operational effectiveness as it provides segregated

and protected spaces for multiple users from various departments in the enterprise.

Fig 3.5 Advantages of UiPath

3.4 FUTURE SCOPE OF RPA

RPA has provided an excellent solution for organizations to replace

repetitive, mundane, rule-based processes with software bots. It is now helping organizations

that were working to increase their workflow accuracy and efficiency? First, RPA was widely

adopted in the IT sector. It amazed many big organizations as well as small and medium

enterprises with outstanding results. Later, it was adopted in other sectors like Finance,

Accounting, Banking, etc. RPA tools are already being used in several organizations. This is

going to be the most important thing in the upcoming years. As it is getting older, more

organizations are coming to know about this technology and its benefits. Many multinational

organizations have already adopted this technology. Now, SMEs (Small and Medium

10
Enterprises) and other mid-cap industries are moving to adopt this technology. The technology

is expected to be used by most of the remaining organizations with the time. RPA is evolving to

include artificial intelligence and machine learning. We can expect that RPA will support

unstructured data processing and simple judgment-based automation in the upcoming days.

This will help RPA to jump beyond just rule-based technology. It is a belief that RPA bots will

be used widely as cloud services. There is a possibility that RPA vendors would be combining

Amazon AWS or Microsoft Azure to deliver their services on the cloud with advanced AI

capabilities. According to the report by McKinsey & Company, it is predicted that RPA will

have a significant economic impact of nearly $5.2 to $6.7 trillion by 2025. A career in RPA can

be beneficial as there is a shortage of resources. The emerging graduates can easily expect a

major share of employment in this field. The salary packages for the professionals in this

technology are relatively higher when compared to other fields. RPA is going to become the

next trending technology and you will have a great opportunity to find thousands of jobs in

upcoming years.

11
 Fig 3.6 Future Scope of RPA

CHAPTER 4

RESULT AND DISCUSSION

4.1 SEQUENCES

Sequences are the smallest type of project. They are suitable for linear processes as they enable

you to go from one activity to another seamlessly and act as a single block activity. One of the

key features of sequences is that they can be reused time and again, as standalone automation or

as part of a state machine or flowchart. For example, you can create a sequence to take

information from a .pdf file and add it to a spreadsheet and reuse it in a different setting, while

changing just a few properties.

12
 Fig 4.1 Sequences

4.2 GET IMAP MAIL MESSAGES

Common

• DisplayName - The display name of the activity.

• TimeoutMS - Specifies the amount of time (in milliseconds) to wait for the activity to
run before an error is thrown. The default value is 30000 milliseconds (30 seconds).

Host

• MailFolder - The mail folder from which the messages are to be retrieved.

• Server - The email server host that is to be used.

• Port - The port used to get the email message.

Logon

• Email - The email account used to get the message.

13
 • Password - The email account’s password is used to get the message.

• SecurePassword - The email account' is used, as a secure string.

Misc

• Private - If selected, the values of variables and arguments are no longer logged at the
Verbose level.

Options

• DeleteMessages - Specifies if the read messages should be marked for delete.

• FilterExpression - Returns only those mail messages matching the filter expression.

• FilterExpressionCharacterSet - The MIME name of the character set to be used for

the filter expression.

4.3 THE FOR EACH ACTIVITY

Common

• DisplayName - The display name of the activity.

Misc

• Private - If selected, the values of variables and arguments are no longer logged at the
Verbose level.

• TypeArgument - A drop-down list that enables you to choose what variable type you
want to use with the activity.

• Values - The variable whose values you want to iterate. This field supports only
IEnumerable variables.

Output

14
 • Index - A zero-based index specifies which elements of the current collection are being
iterated, and stored in an Int32 variable.

Fig 4.2 For Each Loop

4.4 THE IF ACTIVITY

The If activity contains a statement and two conditions. The first condition (the activity in the

Then section) is executed if the statement is true, while the second one (the activity in the

optional Else section) is executed if the statement is false. If activities can be useful to make

decisions based on the value of variables.

15
 Fig 4.3 The If Activity

4.5 SAVE ATTACHMENTS

Saves the mail message attachments to the specified folder. If the folder doesn't exist, it is

created. If no folder is specified, the downloads are saved in the project folder. Files in the

specified folder with the same name as the attachments are overwritten.

Common

16
 • DisplayName - The display name of the activity.

Input

• FolderPath - The full path of the folder where the attachments are to be saved.

• Message - The MailMessage object whose attachments are to be saved.

Misc

• Private - If selected, the values of variables and arguments are no longer logged at the
Verbose level.

Options

• Filter - An expression that is verified against attachment file names to be saved.

• OverwriteExisting - If selected, overwrites an existing file with the same name as the
attachment.

Output

• Attachments - The retrieved attachments.

CHAPTER 5

CONCLUSION AND FUTURE WORK

5.1 CONCLUSION

Thus, this project offers the user to save attachments by training a bot. This is very helpful for

the client to save attachments using a bot. The user is mainly more concerned about the validity

of the data, whatever he saves. It executes in a step-by-step manner. So, it’s easy to analyze

17
each attachment saved in a folder. The bot stores the resources inside a folder automatically

without the need of humans based on the subject of resources. This way the employer and the

employee can save time and increase productivity. The Decision-making process would be

greatly enhanced because of the faster processing of information since data collection from

information available on the computer takes much less than a manual system. This is bound to

be simple and very friendly as per the user is concerned. That is, we can say that the project is

user-friendly which is one of the primary concerns of any good project. These features will

increase efficiency, accuracy, and transparency.

5.2 FUTURE ENHANCEMENT

In the future, this bot can be expanded by adding some features to check whether the given

attachments came from the client. So that the salesperson can verify the mail and store

necessary information about the attachments he received. Further, the bot can be enhanced by

increasing its efficiency of the bot. A collection of information about the sent and received time

can be recorded.

APPENDIX – I

SEQUENCES

18
APPENDIX – II

SNAPSHOTS

19
20
21
 REFERENCES

[1] Chakraborti T. et al. (2020) From Robotic Process Automation to Intelligent Process
Automation. In: Asatiani A. et al. (eds) Business Process Management: Blockchain and
Robotic Process Automation Forum. BPM 2020.

[2] Aguirre S., Rodriguez A. (2017) Automation of a Business Process Using Robotic Process
Automation (RPA): A Case Study. In: Figueroa-García J., López-Santana E., Villa-Ramírez
J., Ferro-Escobar R. (eds) Applied Computer Sciences in Engineering. WEA 2017.

[3] Simone Agostinelli and Andrea Marrella and Massimo Mecella (2020). "Towards
Intelligent Robotic Process Automation for BPMers".

[4] M. Ratia, J. Myllärniemi, and N. Helander. 2018. Robotic Process Automation - Creating
Value by Digitalizing Work in the Private Healthcare

[5] Agostinelli S., Marrella A., Mecella M. (2019) Research Challenges for Intelligent Robotic
Process Automation. In: Di Francescomarino C., Dijkman R., Zdun U. (eds) Business
Process Management Workshops. BPM 2019.

[6] Herm LV. et al. (2020) A Consolidated Framework for Implementing Robotic Process
Automation Projects. In: Fahland D., Ghidini C., Becker J., Dumas M.

[7] J. Chacón Montero, A. Jimenez Ramirez, and J. Gonzalez Enríquez, "Towards a Method for
Automated Testing in Robotic Process Automation Projects," 2019 IEEE/ACM 14th
International Workshop on Automation of Software Test (AST), 2019

[8] Van der Aalst, W.M.P., Bichler, M. & Heinzl, A. Robotic Process Automation. Bus Inf Syst
Eng 60, 269–272 (2018).

22