Adding email addresses to outlook "to" field from access database

[Henrykibz]

Hi,


I would like to know how to add email addresses to the "to" field in outlook from an access database.
I have different groups in my db and each has clients and need to extract the emails per group and export to outlook so i can send one email to a specific group members.

Thanks,
Henry

[pbaldy]

I'm not on a computer right now so can't post code, but basically you'd open a recordset on an SQL string that pulls the desired group. Loop that recordset and build a string variable to use in your email.

[RuralGuy]

My favorite email link: http://www.granite.ab.ca/access/email.htm