Hi,I have a database containing Master Contracts. Any changes to these Contracts must be recorded, but the Main Contract must stay as the original. I use response documents to record any changes, in other words, the last response documents is the most recent/updated Contract. I then need to e-mail this recent/updated Contract every 15th of the month to a specific person to do the Invoicing from the information on the Contract.
Any help will be appreciated.
Regards
Lieschen
Subject: Main Document, Response Documents E-mailed
Hi Lieschen,
You will want to use Lotus Script for this:
Create an agent and schedule it to run on the 15th (or 14th) of each month.
In the agent loop thru all Open Master Contracts and for each one get a collection of response documents. Then check each to find the most recent and send your mail. Should be pretty straight forward. You can make life a bit easier if you are new to LS by making a view that contains only Open Master Contracts and have your first loop traverse this view and a second view that has only response documents (sorted by ParentID) and getalldocuments by key method. HTH.