Opinion - Emailing mail merge

[dniezby]

I'm in the infancy of an application where my users will be able to simply click a button and send a specific form letter to a contact in their database.



Where should I store these mailmerge docs? In the database or in a subfolder with some type of reference to them? Can my users even USE a mailmerge document if I create a runtime application and they don't have word?

I'll also need a way to update those mailmerge documents.

Any thoughts?

Thanks in advance.

[davegri]

Access can generate either the source document or data document as well as the recipient list and place them in a specified folder.
Keep your mail merge documents in that same folder.
Access can call up a Word application to use the documents in that folder.
For mail merge, you can have the Access generated file be used as the data document to fill in the Word fields.
After the Word application is running, the user can edit any changes necessary.

Spend some time with Google. All the information you need is out there.

[dniezby]

Access can generate either the source document or data document as well as the recipient list and place them in a specified folder.
Keep your mail merge documents in that same folder.
Access can call up a Word application to use the documents in that folder.
For mail merge, you can have the Access generated file be used as the data document to fill in the Word fields.
After the Word application is running, the user can edit any changes necessary.

Spend some time with Google. All the information you need is out there.

I've been to Google. It said to come here.