Notification Mail based on Excel data

Home Forums Office Office XP / 2003 General Issues Notification Mail based on Excel data

This topic contains 3 replies, has 4 voices, and was last updated by tehcamel tehcamel 8 years, 2 months ago.

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • Avatar
    trprasad78
    Member
    #153978

    Kindly sugguest.. if there is a due date set in the excel sheet. without opening the excel sheet is there any possibility to get the reminder in outlook

    tehcamel
    tehcamel
    Moderator
    #357090

    Re: Notification Mail based on Excel data

    you could possibly create a macro so that when the due date is originally set, or changed, it creates a reminder in your outlook calendar.

    #344925

    Re: Notification Mail based on Excel data

    An alternative would be to write a script to read data out of the spreadsheet file and create the necessary appointments.

    Why do you not want to open the spreadsheet?

    Avatar
    Ossian
    Moderator
    #184103

    Re: Notification Mail based on Excel data

    You would have to open the sheet, programatically at least, to get the info from Excel
    (unless microsoft have released the Psychic API recently :twisted: :lol:)

    It should be fairly straightforward to write an excel macro to e.g.
    Iterate through a folder
    open each workbook
    check a particular cell
    write an OUtlook item based on the value in that cell

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic.