top of page

Process Deep Dive #2- Reading Emails & Extracting Attachments (from

Extract Attachments

Fig 1, Extract Attachments Page

This page reads the emails loaded into the [Items] collection and saves all the attachments into a unique folder.

[UTC Referral Path] is an Environment Variable that references the root folder to store the attachment referrals.

The Create Item Folder ID calculation stage creates a unique folder name in which to store the referral and uses the logic Right([Items.EntryID], 8) to take the last 8 digits of the EntryID. This is stored on ItemID.

The email is checked to see if it has any attachments using [Items.Attachments]<>"" If not then it is ignored. This decision is necessary to prevent empty folders being created.

The Create Directory object creates a unique folder to store the referral attachment. The Directory Path is created using the input [UTC Referral Path] & [ItemID]. The output from the object includes a Success flag that is used to determine if the process was successful.

Fig 2 - Create Directory Object

The Folder Created decision checks to see if the folder creation was successful using the logic [Success]=True. If the folder was not created then the exception E02 is raised and the whole process fails as there is more likely a larger issue to be resolved.

Using the Save Attachments action, any attachments contained within the email are stored in the unique folder that was created in the previous step.

Write To Queue

The Write to Queue page takes the collection of incoming referrals and writes them to the UTC – Incoming Referrals queue ready for data extraction. The Status for each item is set to Pending.

Fig 3 - Write to Queue

The Archive Email page takes the original email and moves it to an inbox subfolder in Outlook. An Environment Variable called UTC Email Subfolder defines the folder.

The Move Email to Inbox Sub Folder is the action within the MS Outlook Email VBO.

Fig 4 - Move Email to Folder

End of Part Two...

#RPA #AI #ERS #NHS #Email

143 views0 comments
Post: Blog2_Post
bottom of page