Hi all, hope you can help. I have been Googling and searching all morning, but am still stumped. 
I have code which extracts the "body" of an Outlook message and populates to an excel spreadsheet. The problem is that it is very difficult to delimit the data once in excel as many "question marks in boxes" appear within the data.
I want to mimic the operation of:-
1) selecting ALL of the data in the body of a message
2) copying the data
3) pasting straight to excel.
Doing this manually, the data is pasted in a much better format and is easy to delimit.
Hope this makes sense.
Thanks in advance,
Paul.

I have code which extracts the "body" of an Outlook message and populates to an excel spreadsheet. The problem is that it is very difficult to delimit the data once in excel as many "question marks in boxes" appear within the data.
I want to mimic the operation of:-
1) selecting ALL of the data in the body of a message
2) copying the data
3) pasting straight to excel.
Doing this manually, the data is pasted in a much better format and is easy to delimit.
Hope this makes sense.
Thanks in advance,
Paul.