I recieve several E-mail with attached exel docs. And I want to get the content from diffrent cells and store it in a variable to paste it in a Log program that I use. How do I do this? I have attached a excel doc so you can see how it looks. The cells can containe 1 row or more... but the cells that i have filled with Yellow is the the one i want to get
Br// Michael
//Best Regards Michael
| Attachment | Size |
|---|---|
| excel_test.xls | 24.5 KB |



The following blog posts might help you:
http://winautomation.com/blog/using-data-excel-part-i
http://winautomation.com/blog/using-data-excel-par...
The 2 essential differences between your job and the job that is being built in these 2 posts are the following:
1) The "Read from Excel" action, should be changed to read from Row no.15 to FirstFreeRow-1, and from Column no.2 to no.9 (of course all modifications should be made accordingly)
2) Instead of placing a "Send Email" action inside the for each loop, you will have to use a Set Clipboard action to set the contents of the various variables into the clipboard and the Send Keys action to send various keystrokes, like {Control}({V}) that allows you to paste the contents of the clipboard.
==Dedicated Automation Solutions==
==Dedicated Automation Solutions==