add birthday to outlook contacts

Not open for further replies.


New Member
Outlook version
Outlook 2010 64 bit
Email Account

I have a excel file with all my firends' birthday. And I want to add the birthday into the outlook contants in case that I forget it. And is there any fuction in outlook can batch add this ? Add them one by one will cost too much time.

Any help will be appreciated.
No function - i don't even have a macro for this, but it would be possible - the macro would need to find the contact then update it.

Did you try enabling the duplicate contact checker and importing? I'm not exactly sure how it would handle it if the contact only has a name and birthdate though. (Add a category to existing contacts or to the csv before importing so you can easily see which are the birthdate only contacts.)

Another method is use a list view (like Phone list) - enable in-cell editing then add the birthday field to the view. It has a date picker, but it's faster to type the date - you can use 1/1/67 format. It's faster than opening each contact and depending on how many you have, it might be faster than the next method.

If you haven't added attachments to notes or use contact photos*** you can export contacts to csv.

Sort both sheets by name then copy the birthday sheet columns into the exported sheet - assuming you have just name and date columns in the birthday sheet, I'd insert them in column A/b/c and shift the export columns right. Eyeball the names and shift the fields down as needed (you can delete the rows that don't have b-dates).

When finished, copy the date column and paste into the correct export column, delete the extra columns you added. If you don't use categories, add a category so you can identify the imported contacts. If you use categories, add something to the User1 field.

Then import. You'll probably want the duplicate checker off - you'll be asked for each contact otherwise but you could choose Update all. If you don't use the duplicate checker you can spot check a few and compare to the original contacts - when you are satisfied, delete the originals (group by categories or user1). (I recommend waiting at least 2 weeks.)

***If you do use contact photos, i have a macro at that will save contact photos to the hard drive and one that will add contact photos from the hard drive.
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
G Add contacts birthday to calendar Using Outlook 4
G Add Map It button to Custom Contacts Form in Outlook Outlook VBA and Custom Forms 1
G Outlook 2021 Add Picture to Custom Contact Form Outlook VBA and Custom Forms 2
P Can't add custom field to custom Outlook form, it always adds to the Folder instead Outlook VBA and Custom Forms 2
P VBA to add email address to Outlook 365 rule Outlook VBA and Custom Forms 0
S Outlook 2019 Custom outlook Add-in using Visual Studio Outlook VBA and Custom Forms 0
G automatically choosing "add to autocorrect" option Using Outlook 0
F Want to add second email to Outlook for business use Using Outlook 4
K Add an entry to a specific calendar Using Outlook 1
F Add a category before "Send an Email When You Add an Appointment to Your Calendar" Outlook VBA and Custom Forms 0
J Want to create a button on the nav bar (module add-in) to run code Outlook VBA and Custom Forms 2
M "Attachment Detacher for Outlook" add in, does it update the server copy of the email? Using Outlook 1
J Outlook 365 Add keywords from Listbox to the message body where cursor is placed Outlook VBA and Custom Forms 0
O Add Day Number of the year for 2023-2033 Outlook VBA and Custom Forms 5
J GoDaddy migrated to Office365 - Outlook Wont Add Account Exchange Server Administration 21
F Outlook 2019 Outlook 2019 Add and Sync to New computer Comcast server Using Outlook 2
Witzker Add a text line at the end of the note field in all selected Contacts Outlook VBA and Custom Forms 7
A iCloud Outlook Add In is causing Outlook 2021 to crash and got disabled Using Outlook 10
N How to add or delete items to Move dropdown Menu Using Outlook 0
V How to add 'Previous Item' and 'Next Item' to the Quick Access Toolbar Using Outlook 1
Commodore Safe way to add or update holidays; Windows Notifications issue Using Outlook 8
kkqq1122 How would I add Search for attachment name Outlook VBA and Custom Forms 3
L did MS ever add way to text via Outlook Using Outlook 5
P How to add a column named categories when searching in Outlook Using Outlook 0
M add new attendee to existing meetings with VBA Outlook VBA and Custom Forms 5
N Can't create NEW GROUP and add/remove a member from existing Group in Outlook Using Outlook 1
Witzker Outlook 2019 Pls. add a Prefix for OUTLOOK 2019 here Using Outlook 1
P Add inanimate objects to meetings? Using Outlook 1
O Outlook 2010 Add delete button to the side of the message list Using Outlook 1
BartH Add a string to the conditions in .Conditions.BodyOrSubject.Text Outlook VBA and Custom Forms 2
A "Get Add-Ins" - Which Version of Outlook to use Using Outlook 1
D Do I need Exchange Add-In? Using Outlook 6
C-S-R Manage Add-ins (Remove Wunderlist) Using Outlook 6
A iCloud add in problems Using Outlook 4
L Macro to add Date & Time etc to "drag to save" e-mails Outlook VBA and Custom Forms 17
C Looking for feedback on new Outlook Add-in Using Outlook 0
L isn't there an OL add-on that flags addressee before sending Using Outlook 3
S Add VBA save code Using Outlook 0
P Shortcut Pane - add shortcut to Office365 group mailbox Using Outlook 1
Z Add ComboBox Value to Body of Email Outlook VBA and Custom Forms 1
G How to add a folder shortcut to outlook quick access toolbar? Using Outlook 6
G Add to Outlook Contacts - Point to non-default contacts folder Using Outlook 0
M Automatically add senders first name to a greeting Outlook VBA and Custom Forms 1
C Add Form to Appointments Received, Automatically Outlook VBA and Custom Forms 6
O Outlook tasks - Add text column with multiple lines Using Outlook 3
W April 2020 Office 365 Update - Add-Ons fail after Office 365 Update Using Outlook 6
Z Task Filter Not Working When I add too many criteria Using Outlook 0
D Add date next to day name in Outlook Today calendar view Using Outlook 1
D iCloud Add-in not working in Outlook 2013 and Outlook 2016 After Windows Upgrade & iCloud Upgrade Using Outlook 2
P Add Paste Unformatted to QAT Using Outlook 1

Similar threads