Recent content by KPrasanth9

  1. K

    Send On Behalf of Outlook Operation

    Hi Team, I am trying to implement Send On Behalf of Outlook functionality in my process when am implementing that I came across a code which will resolve my issue Resolving Code: var application = new Application(); var mail = (_MailItem) application.CreateItem(OlItemType.olMailItem)...
  2. K

    Need Help in Regex expression

    Hi Team, I need a help in extracting an element from pdf which contains many details I have to extract the Salary amount Example pdf content: Line1: Salary : 45,658.302 Basic Salary: 23,000.54 Line2: Total Salary : 84,937.98 I have given the below regex ...
  3. K

    How to extract table content from outlook into collection

    I am extracting the mail through code stage and I created my own vbo for that Initially i would be checking the count of unread mails if the count is more than zero then i would be extracting the message body along with subject , to,cc etc Regards, Prasanth
  4. K

    How to extract table content from outlook into collection

    I hope Email Pop3/SMTP will not work for outlook as am using Outlook application to extract the Table format inside the Outlook Body, i would like to know if there is any other solution for this ? I got some input from other source saying to convert the body to XML format and then extract the...
  5. K

    Add 7 days to a date

    Hi Team, I have a date and i would be adding 7 days to the existing date if the resultant date is a Sunday or Saturday or any holiday it should postpone the date to Monday or a consecutive date after Sunday or holiday. Thanks and Regards, Prasanth
  6. K

    How to extract table content from outlook into collection

    Hi Team, I would like to extract the table which is present in my outlook body and would like to feed to collection. Please suggest a possible approach to achieve this. Regards Prasanth
  7. K

    Automation Challenge. This looks interesting.

    HI Team, I have completed the challenge with 100%, I have used AA mode to find the elements and used to switch to the text tab and used send Hotkeys to send the attributes to specific fields. Could you guys let me know if there is any other way i can use other than Send hot keys ? Please...
  8. K

    Extracting Values from Collection using Index Number

    Hi Team, I would like to extract the values from the Collection based upon the Index Number Ex: Collection1 { User Name, Password, Address} I would like to extract the User Name rows with the help of Index number, To be in brief if we want to extract User Name values we have to mention...
  9. K

    OpenOutlook Using Code Stage

    Thanks for that It works for me :) have a nice day
  10. K

    OpenOutlook Using Code Stage

    Hi VJR, I thought there is no inbuilt VBO for opening Outlook and i would like to use code stage to Open outlook, as you suggested the VBO to Open outlook i would like to know if we can check if any Outlook instance is already existing or not before opening Hence i would like to know if we can...
  11. K

    OpenOutlook Using Code Stage

    Thanks for the response :) But how can i check if outlook application is alteady launched or not ? It's giving another instance can i resolve that using arguments if so what aegument can i pass to check that Regards, Prasanth
  12. K

    OpenOutlook Using Code Stage

    Hi Team, I am trying to Open the Outlook by running the ExcelMacro, but i would like to Open the Outlook Directly using the Code Stage. I have tried to Give the same code which i have provided in the Excel Macro into the Code Stage but it's not working for me could you guys please help me with...
  13. K

    how to extract the Values in Collection without field values but with current values?

    Hi Guys, I am using an operation "GetWorkbook as Collection" and am not setting up the collection fields and trying to extract the values with the help of a Loop but when i run the loop it's giving me the first value but not others what should i do to resolve that. Please find the attached...
  14. K

    How to Convert any of the Datatype value to String

    Hi Team, Is there any way to convert the datatype of Flab / Number / Byte /Time to String ? Please let me know if there is any function for this. Regards, Prasanth
  15. K

    European currency validation Issue IsNumber(21.345,00) should be true globally

    Here the problem is IsNumeric function is working good when running from the excel but when it comes to the Blue Prism it's not working your first approach will create some issues as we are having a missed currency values as per the below example If the currency has given is in the European...
Top