How to Auto Mark the Task of a Popup Reminder Complete after a Specific Time Period in Outlook

Some users wish that when a task's reminder pops up, after a specific time period, Outlook can automatically mark the task complete. Now, this article will introduce a method to realize this function with VBA code. With accordance to the previous article "How to Auto Dismiss or Snooze Popup Reminders after Several Minutes in Outlook", you can easily set your Outlook to auto dismiss or snooze popup reminders after a specific time period. However, at times, "Auto Dismiss/Snooze" isn't the...

Read more »

How to Batch Open All Linked Contacts of an Outlook Task

If you would like to open all the linked contacts of a task in bulk, you can read this article. Here we will introduce you an easy method to get it. In Outlook, you can link contacts to tasks at will. After you created a task with a lot of contacts linked, if now you need to check these contacts, you will hope to open them in batches. However, Outlook only allows you to open the contacts one by one. You can double click on one linked contact. Then, in the floating window, you can click on...

Read more »

Understand Cascade-to-Null Feature and How it Can Allow the Use of Null Foreign Key

Here we understand the Cascade-to-Null feature in MS Access and how to use it for allowing Null values in foreign key fields. Indexed fields in MS Access are usually not Nulls mainly because the fields have been set with a ‘Required’ property, to ensure that there are values entered for all fields, irrespective of the data type. But as the case maybe there can be situations where having a Null foreign key can actually be of some help. An example can be of a situation where you need to...

Read more »