I am trying to create an agent in my lotus notes to schedule sending mails on specific dates (birthdays) to individuals from an excel sheet. Can someone guide me to create such an agent in lotus notes?
Mrinal Sinha
Subject: A quick guide
Learn LotusScript.Use LotusScript to open the excel sheet as an OLE object.
Use LotusScript to step through the sheet, extracting names and birthdays.
Use LotusScript to check if the birthday is the same day as today, create a mail document, fill in the required email address, message and subject and send it.
When all matching dates have been processed, use LotusScript to close the excel sheet.
The most important bit if you want to do something like this, is to learn how to program in LotusScript. Pretty much all of the people who answer questions on this forum have already taken the time to do this, and as time is money, they are probably quite unwilling to write complete agents for free.
Phil