Expert: Scottgem - 7/4/2009

Question
I’ve seen in your answers you have helped others with the same type of question, but I can’t seem to make the pieces work together.  I can send a specific e-mail to a specific person using a form, but I can’t figure out how to automatically advance the form to the next record and send the next e-mail and continue the process to the end of the records.  Kind of like a mail merge from word, but staying in Access.  I’m a novice at VBA so please go gentle if I need to go to code.  Any assistance/advice you can give would be greatly appricated.

Answer
"but I can’t figure out how to automatically advance the form to the next record and send the next e-mail and continue the process to the end of the records"

That's because there is no way to do that. You are missing an essential piece and that's called looping. You need VBA to do this. In a nutshell, you need to open a recordset and loop through all the records in the set executing a SENDOBJECT method for each record. Look up looping, Do While and Recordsets in Access help for more details.

Hope this helps,
Scott<>
Microsoft Access MVP 2007
Author: Microsoft Office Access 2007 VBA