How do I build a feature into a cell that would send an email rem.
I have a spreadsheet that tracks the processing of orders from creation to
shipment. At one point in the process, I have to fax shipping notifications.
The date this must be done depends on the state where the order is being
shipped. First, can I simply set up Excel to send me an email reminder to
fax the notification? Second, if the reminder can be done, can I specify
when to send it based on state regulations? For example, one state might
require a 2-day notification while another requires a 5-day notification.
How difficult would it be to customize the reminders (assuming it can be done
in the first place) to the requirements of the respective state?
|