Access list integrated into Outlook calendar?

[Darren_workforce]

Hello,

I am very new to Access and have only created a couple lists. I setup one database with the department birthdays. Field1 are the dates; Field2 are the teams that each agent is assigned to; Field3 are the agent names. Is it possible to integrate the list with Outlook so that I have reminders on my calendar for the birthdays without having to reference the database every morning?

And then if any new IDs are added to the database, are those able to automatically be added to the Outlook calendar without any additional pairing?

 

[Micron]

I have code that will create recurring appointments in Calendar with reminders if that will work for you. What it doesn't have is a way to flag old vs new, so I don't know what would happen if you re-ran it. Maybe nothing other than adding any new appointments. You could always try it.

 

[welshgasman]

I would have a date field that shows when any birthday was added. Then when you add new ones, that field would be null and that would be the filter for adding new records. Completing that field when added, of course.

 

[Darren_workforce]

I would have a date field that shows when any birthday was added. Then when you add new ones, that field would be null and that would be the filter for adding new records. Completing that field when added, of course.

That's a great idea. Easier than sending out inquiries everytime I need to update the team since not everyone provides their DOBs. Thank you for that!

 

[Darren_workforce]

I have code that will create recurring appointments in Calendar with reminders if that will work for you. What it doesn't have is a way to flag old vs new, so I don't know what would happen if you re-ran it. Maybe nothing other than adding any new appointments. You could always try it.

It's worth a shot. Is it VBA code? Anything else and our equipment is really locked down by IT so I'm not certain if it would run.

 

[Micron]

Yes, VBA
You can get it here

VBA for Outlook reminders

Hello, I’m trying to setup a VBA to setup a reminder on outlook for scheduling purposes. Column A contains the date and times with half hour intervals starting at 8am and ending 8pm. I want it to pick up information from other columns, but the data from column A to establish the date and...

www.mrexcel.com