Be alerted to upcoming expiration dates

U

ur2slow

Hello, I was trying to find out how I might be able to incorporate int
a Word document a way to be notified of pending expiration dates
Hopefully someone is free and can steer me in the right direction
thanks
Michae
 
B

Bob I

You would not be notified of impending expiration dates unless the file
was opened and the macro ran. Try Outlook Calendar
appointments/reminders instead.
 
U

ur2slow

Hello Bob I, thanks for the reply, Calendar is the way i need to go,
was thinking that there may be something that would highlight when
opened the document (Word) to notify me of upcoming date expiration
again thanks.
Michae
 
B

Bob I

The "expiration" would require a "math" calculation and then a macro
controlled font change to be triggered when the document is opened. Not
easy in a WORD document, but trivial in a Excel spreadsheet using
Conditional Formatting. Of course you will need to open the file to see
the notification.
 
Top