email same message to several records

[Donna]

I would like to have a form that allows my user to select several records by
clicking a check box named "choose" and then click a button on that form that
will allow them to send an email to the records selected. Is there a way to
do this? Thanks for your help

 

[a a r o n _ k e m p f]

I personally prefer sendign email using a stored procedure XP_SENDMAIL

it is quite easy to send a query-- or anything else you want.
But it's not supported unless you use a real-mans database, like SQL
Server

 

[Donna]

From what I can tell by looking this up, I HAVE to have SQL server, which I
don't. Is there some way this can be done without SQL Server? It is a
stand-alone database.

 

[Gina Whipp]

Donna,

Try: http://www.rogersaccesslibrary.com/OtherLibraries.asp there are a few
samples to download. Please ignore Aaron, it is his reply to EVERYTHING!

 

[Donna]

Thank you, I'll check it out.