G oog le BadWeB | Login/out | Topics | Search | Custodians | Register | Edit Profile Ads by Motorcycle.comMotorcycle InsuranceMotorcycle PartsMotorcycle Helmets Motorcycle Tires Buell Motorcycles

Author Message   Pkforbes87 Posted on Wednesday, March 03, 2010 - 03:20 am:        I'm the HAZMAT manager at work, and have an excel spreadsheet that keeps track of MSDS expirations. I have the document set up with conditional formatting to automatically highlight dates that are expired or nearing expiration. My question is - can I write a macro or use another excel function that would automatically send an email using Outlook as soon as one of the expiration dates is within the window that triggers the conditional formatting? I'm using Excel 2003 and Outlook 2003.   Buellkowski Posted on Wednesday, March 03, 2010 - 11:33 am:        Does this link help?   Sifo Posted on Wednesday, March 03, 2010 - 12:57 pm:        Short answer... Yes. It's been close a decade since I've done that sort of thing though. It's going to take some digging to find the correct functions that need to be called to get it done, but I'm confident that it's doable.   Indybuell Posted on Wednesday, March 03, 2010 - 01:26 pm:        Can you move it to a database? Then you could use triggers.

Add Your Message Here Post: -Color- Black Red Green Blue Yellow Purple Orange Cyan Gray White -Font- Arial Courier Symbol Times Verdana -Size- Smallest (-2) Small (-1) Normal Large (+1) Largest (+2) Username: Posting Information: This is a private posting area. Only registered users and custodians may post messages here. Password: Options: Post as "Anonymous" (Valid reason required. Abusers will be exposed. If unsure, ask.) Enable HTML code in message Automatically activate URLs in message Action: