Blue Prism Product

 View Only
last person joined: 11 hours ago 

This community covers the core Blue Prism RPA product.

  • 1.  Send Multiple Files Attachments to 1 Email User

    Posted 11-20-2023 01:48

    Hi guys,

    I have trouble when sending multiple files to Outlook email.

    In my case; I need to download multiple Excel reports in a day (probably 8 or 10 reports), then rename these files and send them to Outlook email.

    All the reports will be formatted as: "Report for [Current Day]_time when downloading report"

    I need to send all the Excel files that I have downloaded in a day to the Outlook email by the end of the day. How can I do that when my files are dynamic? Thank you!

    *I have use SEND EMAIL action with attachment is "Report for "&[Current Date]&"*" - but it doesnt work



    ------------------------------
    Mia Mikela
    ------------------------------



  • 2.  RE: Send Multiple Files Attachments to 1 Email User

    Posted 11-20-2023 07:35

    @Mia Mikela

    When using the send email action you will have to provide the complete path of the attachment without *



    ------------------------------
    Shashank Kumar
    DX Integrations Partner Consultant
    Blue Prism
    Singapore
    +6581326707
    ------------------------------



  • 3.  RE: Send Multiple Files Attachments to 1 Email User

    Posted 11-20-2023 08:30

    Hi Shashank,

    I have tried without * but it's not working. I want to select all the files I want to send to Outlook email....



    ------------------------------
    Mia Mikela
    ------------------------------



  • 4.  RE: Send Multiple Files Attachments to 1 Email User

    Posted 11-20-2023 08:51

    Are you using the outlook VBO?

    Separate the file paths with a semi colon. Like

    C:\Downloads\File1.xlsx;C:\Downloads\File2.xlsx



    ------------------------------
    Shashank Kumar
    DX Integrations Partner Consultant
    Blue Prism
    Singapore
    +6581326707
    ------------------------------



  • 5.  RE: Send Multiple Files Attachments to 1 Email User

    Posted 11-20-2023 19:03

    Thanks,

    Given my case, the downloaded reports are dynamic, and it's not constant. So if I list all the paths manually like you do, it may not work. 

    But thanks for recommending it. 



    ------------------------------
    Mia Mikela
    ------------------------------



  • 6.  RE: Send Multiple Files Attachments to 1 Email User

    Posted 11-22-2023 03:31

    Hi @Mia Mikela

    Send Mail Action takes File path as absolute path meaning you to provide full path of a file/files. If it is multiple files - you have to append paths into single string. Below are the steps how you can do it. 

    As you are creating report on daily basis - I suggest you create a folder with current Date Stamp for that day and place all the report (8-10) over there. 

    To send all reports in a mail you have to create a single string with all file's paths. Here's how you do it: 

    1. As we already created a folder for everyday (using current day stamp) - we should do a get Files inside that folder so we can get all reports for that day. (You can give pattern as you like if you have a preference on only specific file to send)
    2. Once you got the collection of files - loop through each item and append FilePath(absolute path) to a variable (let's say allAttachmentPath) using ";"
    3. then if you add that string(allAttachmentPath) as a value in Attachment parameter of send Mail. It should send out all the files in a mail. 

    Do let me know if you face any issues performing. 



    ------------------------------
    Abhisekh Mukherjee
    ------------------------------



Welcome to the Blue Prism RPA Product Community!

Whether you’re looking to manage a complex infrastructure, maintain security and compliance, bring new products to market faster, or gain operational speed and agility in an uncertain economy, Blue Prism delivers — with the flexibility you need to create the business you want. From deployment on-premise, through a cloud service provider or as SaaS, to a skillful and adaptable digital workforce that continually expands to meet your enterprise needs, you can gain enhanced operational insight and control while your people reclaim the time they need to focus on great work.

Product PageKnowledge BaseBlue Prism Training Offering
Product Research Programv6 End of Life

FAQs

Blue Prism is intelligent automation — business-developed, no-code automation that pushes the boundaries of robotic process automation (RPA) to deliver value across any business process in a connected enterprise.

A combination of RPA with expanded cognitive and AI capabilities, Blue Prism is different than other automation technology on the market. With one Blue Prism license, you gain instant access to an already AI equipped digital workforce, along with the tools you need to build and delegate automations. Click here for more information on Blue Prism and Intelligent Automation.
To learn more about how Blue Prism RPA can help your organization and how much it will cost to get started, please Contact our Sales department.
Blue Prism RPA can be downloaded from our customer portal. If you would like to consume or download any material it is necessary to create an account on the Portal. Once you have registered, you can access the download options for Blue Prism here.
Yes! Installed on your own machine and supported by our training materials and product documentation, you can use all the features of the full enterprise product for free with our Blue Prism Trial – giving you the opportunity to learn the basics before moving to a full production implementation. Click here for more information and to download the trial.
Yes! You can access our known issue list for Blue Prism from our Support Portal.
Regardless of your industry, Blue Prism’s Digital Workforce can adhere to strict governance and compliance standards without limiting productivity. Click here for more information on how your industry can benefit from Blue Prism.