To input into the query i use a form with an update button at the bottom of it.
I have created a mail merge document in word with the same fields as in the query. What i would like to do is click on another button which will then input the data in the query into the mail merge document and then email it to the teacher (email address is in another table).
How do i go abot doing this.
I have tried using the mail merge options in word but i can only get it to send emails to ever teacher, whereas i only want it to send to the teacher in the query.