Add contacts birthday to calendar

Post number 2 has been selected as the best answer.

gaib

Member
Outlook version
Outlook 2016 64 bit
Email Account
POP3
I've imported contacts into Outlook via a .csv file. All of these contacts have birthday's and some have anniversaries. Using VBA, how can I get these birthday's and/or anniversaries to get added to the Calendar?
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange

gaib

Member
Outlook version
Outlook 2016 64 bit
Email Account
POP3
Hi Diane and thank you. The code works fine if I remove the "Option Explicit", but if it's in the module, the code debugs too

mybirthday = myFolder.Items(i).Birthday

How do I declare this?
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
All you need is this:
Dim mybirthday
Dim myanniversary
 
Similar threads
Thread starter Title Forum Replies Date
A add birthday to outlook contacts Using Outlook 1
G Add to Outlook Contacts - Point to non-default contacts folder Using Outlook 0
A Add to Outlook Contacts from email - default view Outlook VBA and Custom Forms 1
daveTQM Add email recipients to contacts Using Outlook 1
Diane Poremsky Add to Outlook Contacts Bug (Fixed) Using Outlook 1
M add contacts to shared contacts distribution list Using Outlook 1
L Macro to Add Catgegory to List of Contacts Using Outlook 4
B how to add country code to contacts automatically Using Outlook 7
P Add Business Contacts to BCM2010 from iPhone BCM (Business Contact Manager) 2
B Would like to add more fields in the Genral contacts tab Using Outlook 1
M How to Create Macro in Visual Basic to add Contacts from Personal Folder Using Outlook 4
C How do I change the default "Add to Outlook Contacts" Folder Using Outlook 6
B Only 249 contacts are allow to be created in Outlook by Add-in Outlook VBA and Custom Forms 5
P How do I create a macro to add contacts from email messages? Outlook VBA and Custom Forms 1
K 2003 Outlook Contacts - how do I add text to multiple contacts .... Outlook VBA and Custom Forms 2
N Adding 'Add To Business Contacts' when right-clicking an email add BCM (Business Contact Manager) 2
S How to add icon(or picture) field for each contact in contacts view Outlook VBA and Custom Forms 6
V How to create add-in to delete duplicated contacts Outlook VBA and Custom Forms 1
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
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
M Ignore slow add-ins Using Outlook 0

Similar threads

Top