and i want to get the following data and SAVE it in excel
Reference No. : KK2252 - John Doe Ordered By : John Doe Order item: New Zealand Cat Kibbles Price : $48.60 Quantity: x1 Description: New Zealand Cat Kibbles | 9 KG (only $0.70 per cup serving) SKU : Seconds (Cat)
Use the Save Mail Message activity to save the body of the mail in the Notepad file.
Then Use the Read Text file activity to read the above Notepad file and store the data in a String Variable.
After storing the mail body data in a string variable, Use Generate Datatable From Text activity to generate the datatable by using the string data.
After that use write range workbook activity to write the datatable in to the excel.
Check the below image what are the activities to use in workflow.