Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 2 of 2

Thread: Update Tasks in Outlook Through Excel Entry

  1. #1
    Join Date
    4th September 2010
    Posts
    1

    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

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    9th September 2009
    Posts
    1,599

    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.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Exporting: Excel to Outlook Tasks
    By mellorb1 in forum Excel and/or Email Help
    Replies: 17
    Last Post: May 25th, 2012, 07:06
  2. Creating Outlook Tasks
    By paulrs in forum Excel and/or Email Help
    Replies: 6
    Last Post: October 3rd, 2006, 22:32
  3. Creating Outlook Tasks
    By paulrs in forum EXCEL HELP
    Replies: 1
    Last Post: October 3rd, 2006, 02:00

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno