How can I export the "Created" date field in contacts?

Status
Not open for further replies.
M

MarinMan

In Outlook 2002/Contacts, I right-clicked on the column names add added the

"Created" and "Modified" date fields, which now display with each contact.

I now want to export by Contacts file, with these fields included. When I

get to the Map Fields part of the Export process, these fields are not

available for selection. Is there a way that I can export them directly from

Outlook? If not, I found an add-on shareware program that claims to be able

to do this. Thanks.
 
K

Karl Timmermans

Create and LastMod date fields (among a host of others) are not part of the

Outlook (any version) export map field group. Aside from writing your own

code, a 3rd party solution is your only option. Depending on the number of

fields you want to capture combined with the number of contacts - an

alternative approach is to create a view with the requisite fields and do a

cut 'n paste into Excel but wouldn't suggest this approach for a lot of

fields and/or a lot of contacts.

Karl

________________

"MarinMan" <MarinMan> wrote in message

news:65963B92-5A0C-4A53-8F27-82602E643366@microsoft.com...
> In Outlook 2002/Contacts, I right-clicked on the column names add added
> the
> "Created" and "Modified" date fields, which now display with each contact.
> I now want to export by Contacts file, with these fields included. When I
> get to the Map Fields part of the Export process, these fields are not
> available for selection. Is there a way that I can export them directly
> from
> Outlook? If not, I found an add-on shareware program that claims to be
> able
> to do this. Thanks.
 

philiptory

Member
Outlook version
Outlook 2010 32 bit
Email Account
POP3
I don't know about earlier versions of Outlook, but this works in Outlook 2010.


  • Select the Contacts tab.

  • Set the system to view your contacts as a List (the appearance is like a table but without the lines).

  • Add a column that shows the Created Date.

    • Right-click on the header bar and select Field Chooser.

    • In the Field Chooser, click on the drop-down menu and select All Mail Fields.

    • Scroll down until you find Created Date.

    • Click on this tab and drag it to the header strip above the list. Drop it in the required position.



  • Use the Search tool if required, to select particular contacts.

  • Click anywhere in the list and use Select All (Crtl+A) and Copy (Ctrl+C).

  • Switch to Excel and Paste it into a blank sheet.

Bingo! All the required information is pasted in OK, including the Created Date.



Philip Tory


Technical Writing Courses at technicalwritingcourse.co.uk
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
Owl Export Outlook PDF Attachment as JPG? Outlook VBA and Custom Forms 3
K Disabling import/export button to restrict PST creation Using Outlook 3
K Export Folder to PST Outlook VBA and Custom Forms 2
R Outlook 2010 How do you export 2 email Accounts' 2010 Inbox Files to new computer (2019)? Using Outlook 0
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 1
S How to export urls from email to excel and check the status of the url ? Using Outlook 5
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 Using Outlook 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
B No export way Using Outlook 4
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

Similar threads

Top