Automation iconExcel iconOutlook icon

Update Outlook Task Reminder Dates from Excel

A few days ago I completed a routine that lets you update Outlook task reminder dates from Excel. For example, if you had a list of tasks in one column, with updated dates in a second column, this routine would allow you to change the reminder date for the task to the newly updated date. Works well if you are managing a project and need to change reminder dates for particular items.

Continue Reading: Update Outlook Task Reminder Dates from Excel »

Automation iconExcel icon

SearchBox Week, Day 3

Welcome back! Today the search term I've chosen is "change reminder date on task VBA". What I'll do is provide some Excel VBA code to allow you to alter a reminder date for an existing task in your Outlook Tasks list. The code also works as a UDF — the cell will change to TRUE if the task was updated, and FALSE if it fails.

Continue Reading: SearchBox Week, Day 3 »

Automation iconExcel iconOutlook icon

Using Excel VBA to set up Task Reminders in Outlook

I know I have trouble remembering when different projects or tasks are due. Here's one way to remember: Set up a list of tasks and due dates in Excel, then use VBA to set up reminders in Outlook.

Continue Reading: Using Excel VBA to set up Task Reminders in Outlook »

Site last updated: February 9, 2012