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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|