Hello, This has two areas i’m struggling with, how to get the body of the emails into an excel sheet in the correct columns, and how to put this data into the next empty row in the excel sheet. I have worked with finding empty rows before but never combining this with placing data from emails into …

@deguy42 have a look at this xaml file Mail Body to Excel File.xaml (9.6 KB)

Copy the body of an Outlook Email and put into an Excel sheet

deguy42 (CG) June 28, 2021, 11:23am 6

Thanks for the help! I have assigned variables for the data. Now do I create a dataRow with these, using an array of my variables?
Also, if I want to grab just the reference number in the item.subject, can I just use the same method?

Empty Email Body Using Gmail

Topic		Replies	Views
Copy the body of an Outlook Email and paste into an Excel sheet Studio studio , question , tools	11	1182	November 17, 2022
Excel to email body Help datatable , excel , mail , outlook , activities , question	4	2860	April 15, 2020
How to extract outlook table data to excel? Activities mail , activities , question	3	575	June 7, 2023
Empty Email Body Using Gmail Studio datatable , excel , uiautomation , mail , activities , studio , question	27	2131	April 10, 2022
Get Email Body Details in Excel cell Rows Help excel , mail , outlook , activities , question	6	1283	December 9, 2019

Copy the body of an Outlook Email and put into an Excel sheet

Related topics