The plan is for the data to arrive in an Outlook mailbox, in the normal work email system (which is an Exchange server). I have experimented with using the Outlook in-built export functionality to get the data into Access but the entire email body ends up as a single field.

As they say I wouldn't have started here but that part of the system was agreed between the corporate IT department and the users before I got involved.