add birthday to outlook contacts

Status
Not open for further replies.

AbrahamB

New Member
Outlook version
Outlook 2010 64 bit
Email Account
IMAP
Hello

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.
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
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 slipstick.com that will save contact photos to the hard drive and one that will add contact photos from the hard drive.
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
P Shortcut Pane - add shortcut to Office365 group mailbox Using Outlook 1
B 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
B 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
M Ignore slow add-ins Using Outlook 0
B Add Prefix text to Subject Line Using Outlook 1
Jennifer Murphy Add birthdays to calendar Using Outlook 7
Z Add text to auto-forwarded e-mail Outlook VBA and Custom Forms 4
P Add, remove, & reorder folder pane Using Outlook 6
L Tired of Outlook disabling Adobe PDF Creator add-in Using Outlook 1
R Add 'Company' to Select Names Form Using Outlook 1
A Outlook 2016 Web add-in missing on some machines Using Outlook 9
P Syncing problems with add-ins Using Outlook 3
Mark Foley Cannot enable add-in in outlook 2010 Using Outlook 0
BretAB Is it possible to add a lookup field to a Message form? Outlook VBA and Custom Forms 4
J Add an Attachment Using an Array and Match first 17 Letters to Matching Template .oft to Send eMail Outlook VBA and Custom Forms 2
iwshim outlook 2013 - I cannot see the "Manage Add-ins" Using Outlook 2
A Add multiple servers "on behalf of" email to "safe senders" list. Using Outlook 1
S Add Exchange Account as Secondary to Existing PST? Exchange Server Administration 1
C Macro to add multiple recipients to message Outlook VBA and Custom Forms 3
A Add to Outlook Contacts from email - default view Outlook VBA and Custom Forms 1
P Add a contact to the New Task in Outlook 2016 Using Outlook 2
e_a_g_l_e_p_i Is there a way to add something that is in the "Format Text" tab to the "basic Text" on the message tab Using Outlook 1
B When working on emails in a certain folder, when I hit reply or reply all, I would like it re always reply all and add an email address to send to Outlook VBA and Custom Forms 3
M Macro to add date/time stamp to subject Outlook VBA and Custom Forms 4
O Outlook on Android - add BCC Using Outlook 2
J Execute Add-In Button from VBA Outlook 2016 Outlook VBA and Custom Forms 1
S Example VBA Macro - To Conditionally Change the From Account and Add a BCC Address on Emails Outlook VBA and Custom Forms 11
B When I add more search strings to RULES, it is not processing them Using Outlook 3
D Add Tetxbox at form open Outlook VBA and Custom Forms 1
Andrew Quirl Open attachment, manipulate without add-on program? Outlook VBA and Custom Forms 5
B Searching for a Add-In Using Outlook 3
J Add Fillable Fields to Existing Template Outlook VBA and Custom Forms 1
J vb to c# for Outlook add-in. Using Outlook 0
S Send email via SMTP - use transport rules to add to senders inbox (then rule to move to sent items Exchange Server Administration 1
R Outlook add-in to create new contact from an email. Using Outlook 0
twofivepie GTD Netcentrics add-in for 2016 Outlook VBA and Custom Forms 13
D Add all meeting rooms to the meeting request by default Outlook VBA and Custom Forms 0
Tanja Östrand Outlook 2016 - Create Macro button to add text in Subject Outlook VBA and Custom Forms 1
C Need VBA code to automatically save message outside outlook and add date Outlook VBA and Custom Forms 1
K add pdf to every reply or forward Outlook VBA and Custom Forms 1
R Add Exchange Account to existing POP3 Outlook 2007 Profile Using Outlook 0

Similar threads

Top