Announcement

Collapse
No announcement yet.

Update Tasks in Outlook Through Excel Entry

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Update Tasks in Outlook Through Excel Entry

    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

  • #2
    Re: Update Tasks in Outlook Through Excel Entry

    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.

    Comment

    Working...
    X