I have a customer that wants to use a mail merge word document to send out emails based on a database, then store a copy of each email in the repository. The workflow would go something like this:
1. Query database
2. For each row in db:
a. Fill out mail merge word doc (store as pdf selected)
b. Send the email (preferably using the electronic document contents as the body, rather than attaching it to the email as a separate document)
c. Create new LF entry
d. Attach pdf from step (a) to the new LF entry
e. Run custom script that converts the pdf to Laserfiche tiff images.
I'm good on all but the using of the electronic document (either word doc or pdf) as the body of the email. Any ideas?