I have a list of users of an application stored in an SQL database. I'd like to be able to email these people with useful information.
Two parts to the question.
How do I send queries to an SQL database from Lotus Notes (v6.5.5), in order to retrieve the email addresses? (I'm okay with what the contents of the query should be, I just need to know how to get Notes talking to the database.)
How do I programmatically store these addresses as a group contact?