cancel
Showing results for 
Search instead for 
Did you mean: 

How to handle 2 objects (2 applications e.g Excel and Outlook)?

Shwetavd
Level 4
My scenario is: Step 1. I have to copy an Excel table from sheet 1 and paste it in outlook as an image in a new email. Step 2. Again I have to copy data from sheet2 and paste it in outlook as an image in the same email below step 1. I have tried but getting an error while switching between those applications. Please help me out on this. Thank you in advance!
2 REPLIES 2

Mario_pa_sutedj
Level 3
Hi there, can share the error message?

Use Excel VBO to show the worksheet. attach to excel try to mark the whole excelsheet by clicking in the room between A and 1. Click ""Copy"" and ""copy as image"" (follow by clicking OK) Then you have a image on your clipboard. Deattach Excel and attach Outlook. Open a new mail. Use environment vbo to past the image to the outlook. Deattach outlook and attach Excel Navigate to sheet2 and repeat. I have no idea if this work but I think this is pretty close to what you ask for. Tips. if you want the image to get under simply use global click on the end of the new mail. (not sure if this work to)