Importing Excel Addresses into Outlook , Problem with birthdays

[stacy0966]

Hi,

I have imported some names and addresses from Excel into Outlook. It worked fine except that the birthdays do not show up on the calendar. I can read up a contact, go to the birthday field and retype the birthday and then save the record and it will then show up in the calendar. I do not want to have to do this for about 600 contacts. Does anyone know a solution to this?

Thanks,

Stacy

 

[SkipVought]

Hi,

What is your import file format? Please post several sample rows that include the headings and data that includes birthdates.

Skip,

_{[red]Be advised:[/red] The dyslexic, agnostic, insomniac, lays awake all night wondering...
"Is there really a DOG?"}

 

[stacy0966]

The format is an Excel spreadsheet. It's not a csv file or tab,comma, text delimited.

Thanks.

 

[SkipVought]

Just copy 'n' paste a few rows.

Skip,

_{[red]Be advised:[/red] The dyslexic, agnostic, insomniac, lays awake all night wondering...
"Is there really a DOG?"}

 

[stacy0966]

Sorry about forgetting this. Thanks for the help.


Name Job Title Home Address City State Zip Code Home Phone Category Department Birthday Notes
Thomas Beasley Comp. Trainer 3443 cotton road Meridian MS 39305 (601)485-7707 SPS User IS 1/25/1943 3/1/1988
Warren E Lonidier Mailroom Clerk 12 east road Meridian MS 39305 (601)482-4220 SPS User IS 5/11/1963 7/15/2001
Stacy Simmons Comp. Trainer 1040 oak lane Lauderdale MS 39335 (601)632-1345 SPS User IS 9/23/1966 1/8/1990