[thelist] Emailings with MS Access

[Johnson Borja See]

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 !