emailing individual report to mass recipients from Access XP

[dawnd3]

I would like to email everyone in a database with a report that has their member information to verify. (there are child tables so I cant just do a mail merge in Word.) Anyway, I know how to set it up so that I can email each person seperatly, but there are over 100 members so I would like to set it up so that it loops to email each one. I am going to email as a RTF Word Doc not a snapshot. I am not much of a coder so can someone walk me through this in baby steps.

I will be using Outlook XP to email.

Thanks,

Dawn

http://www.calliopeconsulting.net

 

[ssatech]

How you doing Dawn? Hope the Bay Area is treating well..
Don't know if this will help. You might take a look at Arvin Myer's sample..EmailSenate example:

http://www.datastrat.com/DataStrat2.html

 

[dawnd3]

Thanks for the info, I am sure I can use that at some point, but not exactly what I need right now. I need to be able to send everyone a separate email with their own separate record from the database (including child records) by just clicking one button. Could that code sample you sent be modified to do that or is there another example out there?

Thanks so much for your help! and I LOVE the Bay Area.

Dawn

http://www.calliopeconsulting.net