Access list integrated into Outlook calendar?

D

Darren_workforce

Board Regular
Joined
Oct 13, 2022
Messages
136
Office Version
  1. 365
Platform
  1. Windows
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?
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.
Sort by date Sort by votes
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.
 
Upvote 0
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.
 
Upvote 0
welshgasman said:
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.
Click to expand...
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!
 
Upvote 0
Micron said:
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.
Click to expand...
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.
 
Upvote 0
Yes, VBA
You can get it here
www.mrexcel.com

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 www.mrexcel.com
 
Upvote 0
You must log in or register to reply here.

Similar threads

tjdrake
  • Solved
Multi-User Access DB Table
Replies
3
Views
1K
Micron
M
K
  • Question
How to shorten vba code without any problems
Replies
1
Views
65
kamranyd
K
R
  • Question
Mail merge to insert the picture in the mail body and schedule the email
Replies
0
Views
867
rafeek4u
R
A
  • Solved
Calendar form cancel button passing data to worksheet
Replies
7
Views
551
AndyEd
A
V
  • Question
Structuring and updating automatically data from a worksheet as separated files of a workbook.
Replies
0
Views
372
vladimiratanasiu
V

Forum statistics

Threads
1,216,499
Messages
6,131,012
Members
449,613
Latest member
MedDash99

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top