Good afternoon,

In Outlook 2010, I have emails saved in a specific subfolder. I would like to export those emails, from that folder, to Excel 2010 The fields I am looking for in Excel are Date, Time, From, Subject, Body Text. The Body text is the big issue I am running into. The other fields I can gather from dragging from Outlook and dropping into Excel. However, this is not capturing the text in the email body. Unfortunately, the text is not standardized across the different emails. I need a code that captures the standard fields (above) and the email text. The email text can be placed into one cell, ideally, any space from the original Outlook email would be converted into a special character in Excel; perhaps the # pound sign to text-to-columns later.

Please let me know if you need any other information.

Thanks you for your time and consideration.

Best,
Sciortmj