A user-friendly mail merge

[BJM]

I have a database for storing school attendance records.
We would like the most user-friendly method of creating a
mail merge letter that would allow not-so-computer-savy
teachers to open the merge file, choose certain students
that were absent without known cause, and send each one a
letter of inquiry home. We have all the student
infomation, etc. in tables in the database and even a
query to filter all students without attendance for a
given period of time. We just need a clean way to send
those records to a pre-fabricated form letter by way of a
merge operation. Ideally, that document should be
available from within the database. Is there any way we
can use a macro to put a link to it on a switchboard?

Thanks for any insight,
BJM

 

[Jim/Chris]

If you want to keep all the information in the database why
not create a report in Access

Jim

 

[Guest]

Can I do that and merge records from a query datasource
like with Word? Dare I be so ignorant as to ask how?

 

[Jim/Chris]

Yes you can. the advantage of using Word is you can add
additional information to the document. Do you want to
initiate the mailmerge from Word or from Access?

Jim

 

[John Nurick]

Hi BJM,

One way is to create the letter as an Access report. If you'd rather use
Word mailmerge, see
http://www.attcanada.net/~kallal.msn/wordmerge/index.html