Update Tasks in Outlook Through Excel Entry

[mauritzr]

Hi all,

I have been lurking on this forum for some time now and it has been a great help in learning how to operate Excel. Recently I have been stumped, I need excel to automatically update the tasks in my outlook calendar. I have attached the actual sheet below. I would like to be able to enter a date under "due date" and have excel create a task (the time is not important) in outlook on the corresponding date that also contains the text from the "conversation notes" and "follow up" fields.

Any help that you can provide will be greatly appreciated!

Activity Tracker Help File.xlsm

[Rob Xaos]

Try this link http://www.dicks-clicks.com/excel/olTask.htm

Don't miss the important point of setting the reference to Outlook Object Library. This may or may not be done automatically for you in 2007. In 2003 you do have to do it manually via Tools > References.