Results 1 to 6 of 6
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    195
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Create Outlook task from Excel information (2003)

    I would like to transfer project information that I have in Excel to the Outlook task folder. Basically I will have Task description, start date, end date, Name of the project as category. Then I would like to be able to update the task in Excel from Outlook.
    Which field to use in Outlook to be able to find the right task in Excel when I want to update the Excel file? My first approach is to pick up an unique field in Outlook after creating the tash from Excel and then put this information in the Excel spreadsheet in front of the task.
    Thank you and regards,
    Marcel

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Create Outlook task from Excel information (2003)

    Wouldn't the Subject property of the Task be suitable? I would put that in Excel from the start.

  3. #3
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    195
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Create Outlook task from Excel information (2003)

    The point is that you can change the subject in Outlook or in Excel and then I lose the link. I was thinking that in the Outlook model, one field represent a unique value like an automatic counter. So I was thinking to take this value from Outlook and then put it in the task line in Excel.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Create Outlook task from Excel information (2003)

    OK, try EntryID then. This is a unique ID assigned to each Outlook object when it is stored (or sent).

  5. #5
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    195
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Create Outlook task from Excel information (2003)

    Very weel, it works fine.
    Now I try to record in Outlook the complete path of the Excel file. Do you know how to get the directory path of the active workbook?
    Thanks and regards,
    Marcel

  6. #6
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    195
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Create Outlook task from Excel information (2003)

    OK, I have it
    Application.ActiveWorkbook.FullName
    Thanks,
    Marcel

Posting Permissions

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