Use entry to auto generate a letter

[templeowls]

This is a really specialized question, so bear with me. I have a database that has customer complaints. Some are minor, and some are major, and there's no separation between the two. Some of the major ones we like to send out letters to apologizing. These letters are standardized and made in Word.

The only difference in each letter is the personal information needs to be changed (name, address, date, etc.). All this information is in each entry. Is there any ability within Access to create a report that is modeled off this letter with empty spaces and then when you select a specific entry within a form, press a button and use the information to fill in the blanks in the report? And then print and send off.

[ranman256]

You may want to use 2 letters (report),
the minor and the major problem report for the user to pick (or determined by a code).

but yes, construct the report just like the letter with fill in the blanks.

[orange]

It would appear to be more efficient to identify the complaints as (requires letter or no letter needed) in some manner.
Of course you would also need to manage the sending of letter(s) to avoid multiple letters to same customer etc.

This is often done with a boiler-pate letter template in Word and filling said template with Customer coordinates.
M$oft info here.

Good luck.

[templeowls]

I guess my question is how exactly do I go about constructing something like that. In a perfect world, I'd love to be in a form that views each entry and there is a button which, if pressed, creates this letter with all the fill ins fileed based on that entry

I just don't really know how to create that

[orange]

Use Google. Watch some tutorials on youtube
https://www.youtube.com/watch?v=Knk03inA0k4
https://www.youtube.com/watch?v=vPAQeawkMg8

Come back with specific questions and/or a sample of your database.

Good luck.