Results 1 to 3 of 3
  1. #1
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    How to export birthdays? (Outlook 6.0)

    Can anybody suggest a way to export birthdays from the Contacts Address Book? That field doesn't show up on the list of fields.
    Wendell

  2. #2
    Silver Lounger Bruce K's Avatar
    Join Date
    Apr 2002
    Location
    Phoenix, Arizona, USA
    Posts
    1,876
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to export birthdays? (Outlook 6.0)

    Hi, Wendell ~

    If you have Outlook as well as OE, it can be done:
    <UL><LI>Open 'Address Book'
    <LI>Open Outlook and go to 'Open contact folder'
    <LI>Go back to 'Address Book' window & select contacts you wish to export
    <LI>Drag & drop to the contact folder in Outlook (click on 'Save and close' after window pops up on each contact you dragged)
    <LI>After you have them in the contact folder, export them using Outlook 'Import/Export' from the 'File' menu (this supports more formats and exports all fields)[/list]If you don't have Outlook, you will be hard pressed exporting birthdays to CSV format. But you can export all fields to vCard format files and then manually edit those files. This will be a ton of work if you have many contacts.

    vCard files look like this:
    <code>

    BEGIN:VCARD
    VERSION:2.1
    N:;cxy
    FN:cxy
    BDAY:20040706 <font color=red><--Birthday</font color=red>
    EMAIL;PREF;INTERNET:XXX@yomama.com</code>


    You may also be able to export to CSV format from another application that supports the vCard format after you create them in OE.

  3. #3
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: How to export birthdays? (Outlook 6.0)

    > This will be a ton of work if you have many contacts.

    Actually, even without another vCard aware application, it would not be too difficult to write a VBScript that reads a folder full of vCard files and writes the data back out as a comma- or tab-delimited text file ready to open in Excel. (Not difficult, but it might take a couple of hours to get it just right. Definitely not the first choice!)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •