Sending Emails from a continuous form

[engrmpk]

I have a continuous form with information on it, I want to send the email to individual student whom I should clicked with option box, I can see the email address on the form, name of students, and also want to include all amounts field (which are 3 also showing on form), one student can have more than one entries, I want to send email to a student once with all info (fields) in email, though as I said that one student have more than one entry, but email should go once per student and also if I clicked the option box, if I don’t click the option box to a particular student, email shouldn’t go for that particular student. It could be possibility that I send emails to all the students by clicking all the option or with master click.
I don’t want to see the emails while sending. It should automate like mail merges do.

I am also attaching the sample db here.

 

[jrbarnett]

Your sample database doesn't include anything indicating attemps so far to get this working. Can you please indicate how far you have actually got with making this work and what parts of it don't work properly so far?

John

 

[engrmpk]

Well i want to write the code which will be written under button so that the emails can be sent by taking values from form.

 

[jrbarnett]

can you post what you have written so far and explain what works and what doesn't?

John

 

[engrmpk]

Sorry it didnt resolve yet, i am attaching what i have done so for.

 

[jrbarnett]

I can't do this for you, but the general theory of how to do this is as follows:

Use nested loops (outer one returning a distinct list of all ticked students, the inner one giving the items for that student), build up the content of the message into a string variable.
You can then use the data from the loops to populate details for an email, whether you want to send it via Outlook, SMTP, or another email system.

John