[thelist] Emailings with MS Access

Johnson Borja See jbs at palindrome.ph
Fri Apr 28 22:18:49 CDT 2006


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



-----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
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
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


* * Please support the community that supports you.  * *

For unsubscribe and other options, including the Tip Harvester 
and archives of thelist go to: http://lists.evolt.org 
Workers of the Web, evolt ! 

More information about the thelist mailing list