Hi all,
I'm trying to copy my Outlook inbox into Excel as I need to compare dates that emails were received. Exporting the Outlook inbox doesn't carry across the date field so I've discovered that simply copying and pasting the inbox works better.
The difficulty I'm having is that it copies the 'Received' field across simply as a time. For example in Outlook it shows as 'MON 06/01/2014 10:41' but only copies across to Excel as '10:41'. The overall inbox looks as below in Excel.
<TBODY>
</TBODY>
I've tried formatting the cell to show a different number type but it juts changes it to random numbers and then reverts back to this each time I repaste.
Can anyone help me please?
I'm trying to copy my Outlook inbox into Excel as I need to compare dates that emails were received. Exporting the Outlook inbox doesn't carry across the date field so I've discovered that simply copying and pasting the inbox works better.
The difficulty I'm having is that it copies the 'Received' field across simply as a time. For example in Outlook it shows as 'MON 06/01/2014 10:41' but only copies across to Excel as '10:41'. The overall inbox looks as below in Excel.
<TBODY> </TBODY><COLGROUP><COL></COLGROUP> |
<TBODY> </TBODY><COLGROUP><COL></COLGROUP> |
<TBODY> </TBODY><COLGROUP><COL></COLGROUP> |
<TBODY> </TBODY><COLGROUP><COL></COLGROUP> | ||||
<TBODY> </TBODY><COLGROUP><COL></COLGROUP> |
<TBODY> </TBODY><COLGROUP><COL></COLGROUP> |
<TBODY> </TBODY><COLGROUP><COL></COLGROUP> |
<TBODY> </TBODY><COLGROUP><COL></COLGROUP> | ||||
<TBODY> </TBODY><COLGROUP><COL></COLGROUP> |
<TBODY> </TBODY><COLGROUP><COL></COLGROUP> |
<TBODY> </TBODY><COLGROUP><COL></COLGROUP> |
<TBODY> </TBODY><COLGROUP><COL></COLGROUP> | ||||
<TBODY> </TBODY><COLGROUP><COL></COLGROUP> |
<TBODY> </TBODY><COLGROUP><COL></COLGROUP> |
<TBODY> </TBODY><COLGROUP><COL></COLGROUP> |
<TBODY> </TBODY><COLGROUP><COL></COLGROUP> |
<TBODY>
</TBODY>
I've tried formatting the cell to show a different number type but it juts changes it to random numbers and then reverts back to this each time I repaste.
Can anyone help me please?