Notification Mail based on Excel data Share on Facebook Tweet on Twitter Share on LinkedIn 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 8 years ago. Viewing 4 posts - 1 through 4 (of 4 total) Author Posts trprasad78Member March 24, 2011 at 11:37 pm #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 tehcamelModerator March 25, 2011 at 1:52 am #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. gforceindustriesMember March 25, 2011 at 10:55 am #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? OssianModerator March 26, 2011 at 12:45 am #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 Author Posts Viewing 4 posts - 1 through 4 (of 4 total) You must be logged in to reply to this topic.