Emailing a record/report/form from within Access

[DeepakK]

Hello, I hope I am posting to the correct forum. I'm relatively new to Access and need some help with an important task for my database.

My database is stores information about students such as name, student number, programme, email, etc. I have a STUDENT form with this information visible.

I also have a another table and MARKS sub form that contains the details of courses completed by the student and results. I have placed the sub form in the STUDENT form and can see each student's details and a list of their courses.

I want to be able to send this information to the relevant student via email. The student should only receive his information and no one else's.

Can this be done? Do I need to create a report first? Should I be using WORD to produce the emails?

Any guidance would be very helpful indeed.

DeepakK

 

[pbaldy]

I would create a report; you have much more control over format, etc. You can base it on a query with a criteria or use this to filter it:

http://www.baldyweb.com/wherecondition.htm

You can use SendObject to email it.