No export way

Status
Not open for further replies.

Berean50

Member
Outlook version
Outlook 2013 32 bit
Email Account
Exchange Server
Hello Diane,

After having found your solution to getting data into Excel without exporting, I have run into an issue where the format of the Modified date in Outlook is not respected once copied to Excel (see attached document). It is strange that this happens only to the Modified date and not the Created date.Do you have any idea why this is happening?

I thank you for your assistance.
 

Attachments

Berean50

Member
Outlook version
Outlook 2013 32 bit
Email Account
Exchange Server
Diane,

I have tried various methods to get it to reflect the correct date format in Excel but to no avail. Even more confusing is that I extracted the Received Date and Modified Date fields in Outlook to Excel and the Modified Date format is correct but not the Received Date. :confused:

Thank you for your time.
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Which date format do you use in Outlook? In a quickie test, you need to use mm/dd/yyyy hh:mm format (or the EU format with dd and mm reversed). Any that include day of the week won't format correctly in Excel - they'll either be treated as text or as times.

I can't repro your screenshot with some cells formatted ok, my results are uniform - the format either works or it doesn't.

excel-formats.png

BTW, the Received format (long date in Outlook) is considered text in Excel.
 

Berean50

Member
Outlook version
Outlook 2013 32 bit
Email Account
Exchange Server
Diane,

Your explanations are logical and true. I have worked around this as I can't change my system date format as other Excel spreadsheets are looking for this specific format. Thank you for your time.

Regards.
 
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
R Outlook 2010 How do you export 2 email Accounts' 2010 Inbox Files to new computer (2019)? Using Outlook 1
O Export Outlook calendar appointments by filters and date range Outlook VBA and Custom Forms 1
M Export-Import .pst file problems Using Outlook 2
M How to export Voting Results with user names and their responses Outlook VBA and Custom Forms 13
J Export Zimbra to Outlook PST Using Outlook.com accounts in Outlook 2
S How to export urls from email to excel and check the status of the url ? New Slipstick.com Articles 6
C Export NSF Lotus Notes files in Outlook PST format? Using Outlook 1
C How to export Outlook data to csv? Using Outlook 0
T How to Export mailbox from Outlook 2019 to MBOX format? Using Outlook 1
M Auto-export mail to Excel Outlook VBA and Custom Forms 2
P How to export voting results using VBA? Outlook VBA and Custom Forms 2
R How To Repair OST File & Export OST File to Outlook PST ? Using Outlook 3
JohnViuf Export task list view settings to other pc Outlook VBA and Custom Forms 16
J Copy or Export Outlook Mail to Excel Outlook VBA and Custom Forms 6
N Export details to a excel spreadsheet using macros Using Outlook 0
avant-guvnor Export Calendar, Birthdays and Holidays Outlook VBA and Custom Forms 0
Diane Poremsky Export (Save) Outlook Contact photos New Slipstick.com Articles 0
K Macro to search emails between two time slots on public folders with excel export Outlook VBA and Custom Forms 12
A How to export one email data to excel Using Outlook 1
B Macro To Create Rule To Export From Certain Folder Email Information in one workbook multiple sheets Outlook VBA and Custom Forms 0
W macro to export outlook emails to excel Outlook VBA and Custom Forms 6
E Exchanger service export detection Exchange Server Administration 1
R Correct a wrong csv export file from WLM 2012 Using Outlook 0
Q Outlook 2016\365 export specific rules to import in another system Exchange Server Administration 1
H How to export *all* fields from Outlook Using Outlook 2
K Export Organizational Forms Library Exchange Server Administration 1
N Export Outlook custom forms fields to excel Outlook VBA and Custom Forms 1
E RSS export as OPML problem Using Outlook 4
A export free / busy from exchange Exchange Server Administration 0
C Export to excel missing items, but a larger total? BCM (Business Contact Manager) 6
M Outlook 2013/365 won't export 99% of my contacts to csv Using Outlook 2
T Outlook 2007 Export tasks to Excel Using Outlook 2
J Opening/Archiving/Import/Export PST files Using Outlook 4
H Select one of Contact-Mailadesses to Export > Excel or Winword Outlook VBA and Custom Forms 2
Sarge USMC Cannot import/export Outlook 13 Using Outlook 6
L Outlook 2007 Codes Export and Import Using Outlook 9
L Outlook 2007 Toolbar Export and Import Using Outlook 7
S Requried a VBA Code to export Calander details to excel... Outlook VBA and Custom Forms 4
Jennifer Murphy Can I export individual emails? Using Outlook 1
R Export Address Book VBA Using Outlook 0
W How to export additional fields in contacts Using Outlook 1
R Recover/export rules from a backup .PST Using Outlook 2
J Formatting Contacts to Export for iPhone Using Outlook 0
F Export Outlook contacts by One Category Using Outlook 1
Jennifer Murphy Difference between export and archive? Using Outlook 10
J How can I EXPORT my email address bok? Using Outlook 1
D Macro to export mail data based on assigned category Using Outlook 3
W calendar contacts export problem Using Outlook 1
M outlook shared calendar data export to excel sheet Using Outlook 1
O Export (save) Outlook Contact photos Using Outlook 2
Similar threads


















































Top