Is there a good way to send customized emails in bulk?
I have to send out many form letter emails to users. The emails must be customized since they contain password information.
The user specific info (name, country, username, password) is stored in Notes docouments. The project specific info (project title, URL) is also kept in Notes documents.
The body of the email is standard and doesn’t exist yet, but would probably be stored in Notes documents – everything else is in Notes.
Basically, I want to create customized emails, based on the body template – a mail merge. But I want to do it in Domino instead of using MS Word’s mail merge (mostly because it just seems wrong to use MS Word when everything is already in Domino and because I don’t know how to do MS Word mail merges, then get the info back into Domino).
Has anyone done this before? Is the best way to do this just to write LotusScript code and perform the merge manually? If not, what is?
Thanks,
-Jeff