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
|
|||
|
|||
Sending email from Access through Outlook
I have a form in Access that send an email, generally to over 200 people. It
works except that a dialog box pops up asking to allow the access for each individual email. How can I get the email to just go? I have checked my Outlook and McAfee and can not find anything to change. Currently, it is in Access 2002 and Outlook 2002. Someone mentioned an add on program but I have not been able to find it. Thanks Terri |
#2
|
|||
|
|||
Sending email from Access through Outlook
Wayne Phillips has some suggestions he
http://www.everythingaccess.com/tuto...curity-Warning (His third suggestion looks good for Outlook 2003.) -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "tgavin" wrote in message ... I have a form in Access that send an email, generally to over 200 people. It works except that a dialog box pops up asking to allow the access for each individual email. How can I get the email to just go? I have checked my Outlook and McAfee and can not find anything to change. Currently, it is in Access 2002 and Outlook 2002. Someone mentioned an add on program but I have not been able to find it. Thanks Terri |
#3
|
|||
|
|||
Sending email from Access through Outlook
There is a free dll named Redemption that will do exactly what you want:
http://www.dimastr.com/redemption/ -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "tgavin" wrote in message ... I have a form in Access that send an email, generally to over 200 people. It works except that a dialog box pops up asking to allow the access for each individual email. How can I get the email to just go? I have checked my Outlook and McAfee and can not find anything to change. Currently, it is in Access 2002 and Outlook 2002. Someone mentioned an add on program but I have not been able to find it. Thanks Terri |
#4
|
|||
|
|||
Sending email from Access through Outlook
On Nov 23, 7:21 am, tgavin wrote:
I have a form in Access that send an email, generally to over 200 people. It works except that a dialog box pops up asking to allow the access for each individual email. How can I get the email to just go? I have checked my Outlook and McAfee and can not find anything to change. Currently, it is in Access 2002 and Outlook 2002. Someone mentioned an add on program but I have not been able to find it. Thanks Terri Terri, You can also download a free copy of "Click Yes" utility to automatically click yes for you, no coding required: http://www.snapfiles.com/get/clickyes.html -- Shiller Calixte http://AccessWiz.blogspot.com/ |
#5
|
|||
|
|||
Sending email from Access through Outlook
"Shiller" wrote in message
... You can also download a free copy of "Click Yes" utility to automatically click yes for you, no coding required: http://www.snapfiles.com/get/clickyes.html You can, but you have 2 problems that aren't solved. First, the dialog considerably slows down the code, so even if it clicks yes, it will add several seconds to the execution of each email. Second, you would have the same problem as using SendKeys, namely if another process were to grab focus, you'd be clicking yes. So what would have if your browser was at a malicious site that wanted to download something evil, and you automatically clicked yes? -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com |
Thread Tools | |
Display Modes | |
|
|