Report Setup in Access

[EBox]

I was hoping someone could help me with creating some reports in an Access database.

I currently have a Form which shows 1 record at a time where I populate complaint information from a customer.

As many of the complaints fall into about 9-10 categories, I have standard templates for letters that would go out to customers, depending on which category their complaint fell into.

What I would like to do is have some type of feature (button or drop down list maybe) that will allow me to select or click on a list of these 9-10 form letters and then drop in selected fields from that record into the templated letter so that it can be printed.

Could someone help me with this?

Thanks in advance!

EBox

 

[dhookom]

There is a mail merge functionality in the query by form at

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

It basically uses a memo field to store the letter. The user has the ability to insert merge fields. Code is used to replace field values with the merge field codes.

Duane
Hook'D on Access
MS Access MVP