1. On the Guest Edit form, three new controls were added for the new notifymsg, notifydate and notify_sp columns in the guests table. They are labeled Guest Notification Message, Notify Until, Notify Salespoint Operator respectively. Tooltips were added of, “Text describing this guest which is sent to the notification recipients. Leave blank to never notify.”, "Leave blank to never expire." and "Notify the salespoint operator with this message when guest is put on a sale or reservation".

2. The first time a sale is saved or finalized which has associated guests, look up the each guest's three new notification columns. If notifymsg is not blank and notifydate is blank or later than the current date, create a new 6-"Notify Guest On Sale" log entry in the sp_log table. Tag_line column contains: "Notify Guest On Sale, Guest NNNNNN". Details column contains, in plain text one item per line, the following: "Sale NNNNNN", guest first and last name and guest number, custom message from guests.notifymsg column, line item start date and item description if associated with a line item. No need to store salespoint, operator and datetime information in the Details column because there are already distinct sp_log columns for these. If this guest is linked to more than one line item, only one sp_log entry is needed, just list all the line item start dates and item descriptions in the details column. Finally, if the guests.notify_sp column is TRUE, pop up a dialog which displays the contents of the notifymsg column.

3. The first time a reservation is saved or finalized, look up the reservation guest's three new notification columns. If notifymsg is not blank and notifydate is blank or later than the current date, create a new 7-"Notify Guest On Reservation" log entry in the sp_log table. Tag_line column contains: "Notify Guest On Sale, Guest NNNNNN". Details column contains, in plain text one item per line, the following: "Reservation NNNNNN", guest first and last name and guest number, custom message from guests.notifymsg column, reservation arrival date. No need to store salespoint, operator and datetime information in the Details column as there are already distinct sp_log columns for these. Finally, if the guests.notify_sp column is TRUE, it pops up a dialog which displays the contents of the notifymsg column.