A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Send e-mail with Access



 
 
Thread Tools Display Modes
  #1  
Old April 9th, 2009, 01:29 PM posted to microsoft.public.access
sweeneysmsm
external usenet poster
 
Posts: 74
Default Send e-mail with Access

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
  #2  
Old April 9th, 2009, 02:14 PM posted to microsoft.public.access
Mark Andrews[_2_]
external usenet poster
 
Posts: 600
Default Send e-mail with Access

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" wrote in message
...
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



  #3  
Old April 9th, 2009, 08:42 PM posted to microsoft.public.access
sweeneysmsm
external usenet poster
 
Posts: 74
Default Send e-mail with Access

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



"Mark Andrews" wrote:

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" wrote in message
...
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




  #4  
Old April 9th, 2009, 08:44 PM posted to microsoft.public.access
sweeneysmsm
external usenet poster
 
Posts: 74
Default Send e-mail with Access

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

"Douglas J. Steele" wrote:

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

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"sweeneysmsm" wrote in message
...
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




  #5  
Old April 10th, 2009, 02:38 PM posted to microsoft.public.access
Mark Andrews[_2_]
external usenet poster
 
Posts: 600
Default Send e-mail with Access

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

"sweeneysmsm" wrote in message
...
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



"Mark Andrews" wrote:

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" wrote in message
...
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






  #6  
Old April 10th, 2009, 10:26 PM posted to microsoft.public.access
Tony Toews [MVP]
external usenet poster
 
Posts: 3,776
Default Send e-mail with Access

sweeneysmsm wrote:

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/
  #7  
Old April 30th, 2009, 05:15 PM posted to microsoft.public.access
sweeneysmsm
external usenet poster
 
Posts: 74
Default Send e-mail with Access

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" wrote:

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

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"sweeneysmsm" wrote in message
...
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




  #8  
Old April 30th, 2009, 08:43 PM posted to microsoft.public.access
Douglas J. Steele[_3_]
external usenet poster
 
Posts: 3,143
Default Send e-mail with Access

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.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"sweeneysmsm" wrote in message
...
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" wrote:

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

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"sweeneysmsm" wrote in message
...
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






 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:32 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.