AddIns iconExcel icon

Shipment Tracking Add-in Update

An update to the Shipment Tracking Add-In is available.

Continue Reading: Shipment Tracking Add-in Update »

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 iconOutlook icon

Add To Outlook Calendar UDF

Here is a simple UDF that adds an appointment to your Outlook calendar. It can be used from Excel or VBA, and it should be usable from Access as well (untested). It uses another concept I've also been trying out: checking functions to make sure they are successful by using Boolean return values. I believe I read this in Professional Excel Development, but I'd be hard pressed to find the page number. :)

Continue Reading: Add To Outlook Calendar UDF »

Excel School