Excel to Outlook

[Roni]

I have a list of birthday dates (just month and day) and names in Excel (columns A and B respectively). What i'd like to do is somehow have my Outlook calendar be updated with the birthdays (automatically) and have a reminder sent to me each month/day a birthday is coming. is this possible????

 

[hatman]

Check out this article...

 

[Roni]

that's a bit above my learning curve... do i put those scripts in excel? in outlook? What does this first line mean "Before you can use these example you must set a reference to the Outlook Object Library." ?

 

[hatman]

All of this code gets placed inside of the Excel Workbook. With the workbook containing your dates, you press Alt+F11 to open the VBA editor. Then you need to install the Outlook object plugin to this file: select Tools->References and place a check next to Microsoft Outlook 11.0 Object Library. Now you have given excel th eproper tools to manipulate Outlook.

Then select Insert->Module, and this is where you enter code. The sample code that is listed in the referenced article is simply a set ofinstructions to create a single new appointment. In your case, you would need to write other code to loop and create one new appointment for each entry in your list.

If ll of this is Greek to you, you may wish to take a step back and learn some fundamentals before trying to move too far forward...

 

[kjharve]

I've just come across this post and this relates to something I have been trying to do with Excel and Outlook.

I am using similar code to that in the above link to open the default calendar but what I want to do is open someone else's calendar. Any idea how I can do this?

Ultimately, I'd like to populate Outlook from Excel too but I'm taking things slow at the moment.

 

[hatman]

OOhhh, that's a tricky one... but I'd start here: http://www.microeye.com/resources/ObjectModel2003.htm