Extract text from an email document and save it to an excel file. The target text consists of two lines, a file name and a password. The emails will all have the same name.
Write to an excel file, adding the file name and password in separate cells and then saving the excel file with the file name as its’ name.
Finally, opening up a PDF file with the same file name and inputting the password that was saved from the email into the password field of the PDF.
Any and all help y’all can provide would be greatly appreciated. I’m very new to UiPath.
I’m running into all kinds of issues with this. Like I said, I’m very new to UiPath and have not written any automations for outlook yet. I’m still going through the training courses that are provided.
I cheated a bit and used the “generate” resource to build the automation. The automation is successfully recognizing the target email, but it is not creating an excel file to save the filename and password in. This is what was created:
Thank you for the replies. I have been able to get this automation to successfully pull the file name out of the email and save it to an excel file. But, it still is not extracting the password. The password is unique for each file name that the system shares. I have the starting text show as "Password : ", which is how it is written in the email. For the ending text, I have “–”. Is there a better option for the ending text for the password?
Victory! I had to put in a return between quotations for the system to recognize the password. In the email, there’s no text after the password, just a few blank lines before the next character appears. Thank you for your help.
