Automated Email / Mail Merge

[ItsMe]

You can play around with Debug.Print rs![NameOfField]



You can add additional lines to test multiple fields.
Debug.Print rs![NameOfField]
Debug.Print rs![NameOfField]

Once you have that figured out, you can edit the To string
from
.To = "Address@Domain.com"

so it is something like
.To = rs![NameOfField]

[kazaccess]

Great, I figured it out. Thanks a lot for your help. I appreciate it.

[ItsMe]

Good to hear. There are other ways of sending email too. What you have there is not an easy thing to learn. Now that you have it, you can look at other possible methods and maybe incorporate other features. Let us know if you need help with some formating/concatanation of your Email Body.