I am creating a process, where the robot is opening an e-mail, and with hotkeys finding the line, where there is a part of a text to copy. I copy the text part with the hotkey command ctrl+shift+arrow left.
I am copying text from Microsoft Outlook.
My problem is, that when I have marked the text with the hotkey command, the next thing the robot should do is copying the marked text with ctrl+C. When the robot is using the hotkey with ctrl+C it does not copy the text, but it opens a window for “creating a new user”.
This command is normally accessed in Outlook by pressing ctrl+shift+C, but the robot does not press shift in the hotkey. I dont know why it wont just copy the text instead of opening this window. What can I do to make it copy the text, so I can insert the copied text in a spreadsheet? (And is there an easy way to enter it in a spreadsheet?)
It copies the text now, and then it enters it in a spreadsheet
Now I want the robot to loop/continue the process, and get textparts from all the other e-mails in a folder. how can I do that?
Here is the address and housenumber from the e-mail. How do I get it to jump to next line and fill in the data in B3, and A3?(and so forth from every mail?)
The robot copies the text via “copy selected text”
And then I use variables to store these values in
And then I use the command “Write cell” to insert the two variables (vejnavn and husnummer)
So any ideas to how I can make the robot open every mail, and then copy the data, and fill the copied text into the cells all the way down?
@Kekth, Then you can set an integer variable and initialise to 2 - The first cell you wanna start writing. Then followed by incrementing the count variable for writing down to next cell . That can be passed to cell property.