Send e-mail with Access

[sweeneysmsm]

I have created a membership database for an organization. There is a field
for Member's e-mail address.

Is there a way to send an e-mail to ALL memberS or certain memberS based on
a query (e.g. a notice) from Access? If so, how does one set this up.

Any insight greatly appreciated.

Mary

 

[Douglas J. Steele]

See whether Arvin Meyer's EmailSenate2K at
http://www.datastrat.com/DataStrat2.html meets your needs.

 

[Mark Andrews]

Take a look at this
http://www.rptsoftware.com/products/email/

You might as well customize each e-mail and track which emails went out and
which ones didn't and do nice HTML formatting.

You just pass the main function the sql you want to use to drive the email.

HTH,
Mark

 

[sweeneysmsm]

I was looking for something that I could get or buy as a developer and
utilize in the applications that I develop. As I read rptsoftware.com it
would seem that my users would have to purchase this for each instance. Not
so good, but thanks for trying.

Mary

 

[sweeneysmsm]

Thank you for your help. I will try to give EMail Senate a go. Will post
again after Easter when I will have time to try it.

Mary

 

[Mark Andrews]

Yes the normal price is a site license. I am more than happy to negotiate
an unlimited distribution license.
We have other customers with this type of license. Thanks for pointing out
this point, I'll tweak the website wording to indicate that users should
call
for details of other types of licenses.

Step 1 is still try the little demo.

Sorry for the confusion,
Mark

 

[Tony Toews [MVP]]

I have created a membership database for an organization. There is a field
for Member's e-mail address.

Is there a way to send an e-mail to ALL memberS or certain memberS based on
a query (e.g. a notice) from Access? If so, how does one set this up.

See the Sample Code illustrating looping through a DAO recordset page
at the Access Email FAQ at
http://www.granite.ab.ca/access/email/recordsetloop.htm

Microsoft Access Email FAQ
http://www.granite.ab.ca/access/email.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[sweeneysmsm]

Mr. Meyer's sample worked just fine with the necessary adaptation. Thank you
so much. I guess I had hoped for one that I could just use to send e-mail but
perhaps in Access one always has to structure the initial form to send an
"object". I can always have them delete the attachment later.

Thank you for your help.

Mary

 

[Douglas J. Steele]

What e-mail client are you using? If, for example, you're using Outlook, you
should be able to automate it so that it's not necessary to include an
attachment. If, however, you're using Outlook Express (or Windows Mail),
automation isn't possible.