A user-friendly mail merge

  • Thread starter Thread starter BJM
  • Start date Start date
B

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
 
If you want to keep all the information in the database why
not create a report in Access

Jim
 
Can I do that and merge records from a query datasource
like with Word? Dare I be so ignorant as to ask how?
 
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
 
Back
Top