Hi The following command sends an email from inside an access application DoCmd.SendObject acSendNoObject, , , strTo, strCC , strBCC, strSubject, strMsg, True The parameters are self-evident except for the last part. If true, it opens your default mail editor and lets you edit the message, and false sends the message right away. You'll have to right some codes to return a recordset containing your names and email address and feed them though the docmd object Regards, Jones -----Original Message----- From: thelist-bounces at lists.evolt.org [mailto:thelist-bounces at lists.evolt.org] On Behalf Of Ken Moore Sent: 28 April 2006 04:24 To: thelist at lists.evolt.org Subject: [thelist] Emailings with MS Access Hi all, I have about 375 names in a MS Access table complete with email addresses and permission to contact people. Each person has checked one or more of about 20 areas of interest on a site, collected into MySQL, and downloaded. Running a query and getting the results is no problem. What I want to do is to create a form, write a message, and send them an email. I have seen programs that do this for $500 but I may want to distribute the program to others. Doing this thru Access would allow non-technical types to run it. Does anyone know of an Access program that does this? _________________________________________________________________ Express yourself instantly with MSN Messenger! Download today - it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ -- * * Please support the community that supports you. * * http://evolt.org/help_support_evolt/ For unsubscribe and other options, including the Tip Harvester and archives of thelist go to: http://lists.evolt.org Workers of the Web, evolt !