Support Portal

for ProcessRobot and WinAutomation

Start a new topic
Answered

retreive email in excel using winautomation

I have used retrieve email action, i need subjects, body of the mail, from in the excel sheet,  I have tried by below method but i did not get the output as expected

image

kindly help me on this



Best Answer

Hello Priyanka,


Use "Launch Excel" action outside the "For Each" loop, as it launches new excel for every single item and writes in it.


Also, under "Write to excel worksheet" action, the row field should be increased using a variable, else in each iteration it will update the data only in Row 1 and column 1.


image


I hope it helps.


1 Comment

ADMIN
Answer

Hello Priyanka,


Use "Launch Excel" action outside the "For Each" loop, as it launches new excel for every single item and writes in it.


Also, under "Write to excel worksheet" action, the row field should be increased using a variable, else in each iteration it will update the data only in Row 1 and column 1.


image


I hope it helps.


Login or Signup to post a comment