[thelist] Emailings with MS Access

A Maynes andrew at milords.com
Fri Apr 28 02:32:16 CDT 2006

I wonder why MS haven't bundled something into Access!

Security issues maybe?


>-----Original Message-----
>From: Ken Schaefer [mailto:Ken at adOpenStatic.com] 
>Sent: 28 April 2006 02:03
>To: thelist at lists.evolt.org
>Subject: Re: [thelist] Emailings with MS Access
>:  -----Original Message-----
>:  From: thelist-bounces at lists.evolt.org [mailto:thelist-
>:  bounces at lists.evolt.org] On Behalf Of Ken Moore
>:  Sent: Friday, 28 April 2006 6:24 AM
>:  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?
>Off the top of my head, I don't know of any programs that do this.
>However, your requirements amount to:
>a) a single form
>b) a single query
>c) a few lines of VBA that would merge the message entered in 
>the form, create an email message for each result returned by 
>the query, and send an email somehow.
>Probably less than a day's work for an Access programmer, 
>provided they had a good set of specifications. Quick google 
>search indicates a couple of hits, and a product that sells 
>for $30 that claims to be able to do this. Obviously if you 
>want to redistribute it, you'd need to licence it 
>appropriately. Might be easier to write your own to avoid the 
>licensing issues.
>My IIS Blog: www.adOpenStatic.com/cs/blogs/ken
>Tech.Ed Boston 2006 See you there: Everything the web 
>administrator needs to know about MOM 2005
>* * 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