Outlook vba to copy date from email body to excel

[LisaB]

Hi All,

I have written the below vba code in outlook to extract data from email body on to .txt file. It worked great but I now need to amend this to copy the data from email body to excel spreadsheet . Can anyone please help me in this? The code should open excel workbook saved down in a shared folder and copy the data from the emails on to Sheet1 and then save/close it .

I am unable to add the code below as getting post denied message so please see attachment for code.

Thanks Lisa