Came across this while researching a client requirement and thought it was worth a mention. The project can be found here on OpenNTF. The basic premise is a set of LotusScript agents to allow a user to create, preview and send personalised mail-merge emails through Lotus Notes to a set of recipients based on Excel spreadsheet data.
If you are looking to facilitate something like this – its well worth a look through David Turner’s information and notes on it – just follow the link above.