PinkNotes™ Plus allows you to edit its databases because they are in a Microsoft Access format. Therefore, you can make PinkNotes™ Plus work with software that you have developed. This allows you to add messages from your software by editing the 'Send Later' database. The 'Send Later' database is located in the folder that you have the PNP Master installed in and its file name is called 'PNP4Fut.mdb'.

Whenever you do a send later, a record in the PNP4Fut.mdb database is created with a send date and time. The PNP Master then puts the date and time into a timer and waits until that date arrives, then sends the message. If you add your own records into that database they will not be put into the masters timer. So, to take care of this we have added a setting in the PNP Master Settings, that you can set yourself, for how often you want the PNP Master to check for new records. It can be every 30 sec, every min., every 5 mins. This setting is located at the bottom of the Options tab in the PNP Master Settings.

There are five fields in each record. sendDate, message, id, fromName, and repeat

"sendDate" is the date and time the message is to be delivered
"message" is the actual message string that is sent to the PNP Clients
"id" is a random string of numbers (each id must be unique)
"fromName" is the username of the sender
"repeat" is how often the message is sent - repetition then a comma, period then a comma, and until date (this field is not required)

The easiest way to see what the database looks like is to open the PNP4Fut.mdb file is MS Access.

The 'message' itself has 32 fields of its own. With each field seperated by the following: "`~`"

Here are the fields in order:
=============================
m_sendNow (always False for Send Laters)
m_toMaster (not required for Send Laters)
m_masterAddress (not required for Send Laters)
m_toName (has commas and a space before every name)
m_fromName
m_carbonCopy (has commas and a space before every name)
m_sendDate (date and time)
m_repeat (repetition then a comma, period then a comma, and until date - not required)

m_urgent (True or False)
m_mustAcknowledge (True or False)
m_confidential (True or False)

m_subject
m_field(1 to 7)
m_checkBox(1 to 7) (True or False)

m_message (message in rich text format - does not have to be rich text format)

m_resend (only used when a message is re-sent, can be left blank for send laters)
m_comments (not used with Send Laters)
m_attachName (not used with Send Laters)
m_attachSize (not used with Send Laters)
m_attachment (not used with Send Laters)

NOTE: in the database True is a One (1) and False is a Zero (0).

Please take a look at our VB6 example code to get an idea of how this works.