How to Preserve Email Sent Date When Copying Outlook Messages to SharePoint
Question details
Users need a way to retain and display the original sent date of an Outlook email when moving or uploading the MSG file to a SharePoint library.

- Product
- Microsoft SharePoint, Microsoft Outlook
- Device & OS
- not provided
- Scenario
- Uploading or copying saved Outlook messages (.msg files) to a SharePoint document library for archiving or sharing.
- Observed behavior
- SharePoint automatically displays the file's copy or upload date as the 'Modified' and 'Created' date, effectively hiding the email's original sent date.
Ensure you have the necessary 'Edit' or 'Full Control' permissions in your SharePoint Document Library to create and modify custom metadata columns.
Create a Custom Date and Time Column in SharePoint
Add a dedicated metadata column to manually record or extract the original sent date of the MSG file.
When an MSG file is uploaded, SharePoint treats it as a newly created file in that environment, stamping it with the current date. The default system 'Modified' and 'Created' columns cannot be changed manually. The most reliable method to preserve the email's sent date is to create a custom metadata column in your document library.
Open your SharePoint Document Library, click the Gear icon (Settings) in the top right corner, and select 'Library settings'.
Select 'Create column', name it 'Original Sent Date' (or a similar clear title), and choose 'Date and Time' as the information type. Click 'OK' to save.
Drag and drop your saved Outlook .msg file from your computer into the SharePoint library.
Select the newly uploaded MSG file, open the details pane (or click the ellipsis and choose 'Properties'), and manually enter the email's actual sent date into your new 'Original Sent Date' column.

Automate Metadata Extraction Using Power Automate
Set up a Power Automate flow to automatically capture the email's sent date and populate the custom SharePoint column upon upload.
Looking for a Lightweight Alternative for Document Management?
While Microsoft SharePoint and Outlook are often used for complex corporate email archiving, they can be heavy and difficult to configure. For your daily document processing, spreadsheets, and presentations, WPS Office provides a lightweight, highly compatible alternative without the steep subscription costs.
- 1. Download the Installer: Visit the official WPS Office website and download the free installation package for your operating system.
- 2. Install WPS Office: Run the downloaded file and follow the quick setup wizard to install the software suite on your device.
- 3. Open Your Office Files: Launch WPS Office and instantly open, edit, and save your existing Office documents with perfect formatting preservation.

Frequently Asked Questions
Why does SharePoint change the date of my uploaded files?
SharePoint tracks file activity based on when a file is introduced to its database. When you upload a file, SharePoint registers that exact moment as the 'Modified' and 'Created' date within its system, overwriting the file's local system metadata.
Can I edit the default Modified date column in SharePoint?
No, the default 'Modified' and 'Created' columns in SharePoint are system-generated and read-only. To store historical dates like an email's original sent date, you must create a separate, custom Date and Time column.
Does saving the email as a PDF preserve the sent date better?
Converting an email to a PDF will visually stamp the sent date inside the document's text content, ensuring it is always readable. However, the actual file metadata in SharePoint will still show the date you uploaded the PDF as the system Modified date.




