Access & Outlook
in [General]
|
From: PeterM on 17 Dec 2005 00:38 We have some VBA code that generates and automatically sends emails..the code looks like... Dim mobjoutlook, mobjcurrentmessage Set mobjoutlook = CreateObject("Outlook.application") email_form = email_form_name Set mobjcurrentmessage = mobjoutlook.Createitemfromtemplate(email_form) send_to = customer.HyperlinkAddress mobjcurrentmessage.Recipients.Add (send_to) mobjcurrentmessage.send it works great, however...when it executes the .send, we get a warning from Outlook that another program is attempting to access Outlook and we have to allow the access for 1 minute to 10 minutes. My question is...is there a way to eliminate this warning? I've tried docmd.setwarnings false before the ..send and docmd.setwarnings true right after the send, but the message persists. Please help...we need to send emails to many people, (100+) at a time and it's not feasible to have someone sit there answering the same question over and over. Thanks in advance for your help!
From: Douglas J. Steele on 17 Dec 2005 07:27 Questions regarding the Outlook Security prompt are asked very frequently. The most complete answer has been provided by Outlook MVP Sue Mosher and is as follows: BEGIN QUOTED MATERIAL: "The security dialogs that pop up when an application tries to access certain Outlook properties and methods are designed to inhibit the spread of viruses via Outlook; see http://www.slipstick.com/outlook/esecup.htm#autosec. If you are a standalone user, Outlook provides no way to suppress this behavior. However, you can use a free tool called Express ClickYes (http://www.express-soft.com/mailmate/clickyes.html) to click the security dialog buttons automatically. Beware that this means if a virus tries to send mail using Outlook or gain access to your address book, it will succeed. "If you're the administrator in an Exchange Server environment, you can reduce the impact of the security prompts with administrative tools. See http://www.slipstick.com/outlook/esecup/admin.htm "If it's an application you wrote yourself, you can use one of these approaches to redo the program: -- Use Extended MAPI (see http://www.slipstick.com/dev/mapi.htm) and C++ or Delphi; this is the most secure method and the only one that Microsoft recommendeds. -- Use Redemption (http://www.dimastr.com/redemption/), a third-party COM library that wraps around Extended MAPI but parallels the Outlook Object Model -- Use SendKeys to "click" the buttons on the security dialogs that your application may trigger. See http://www.slipstick.com/outlook/esecup.htm#autosec for a link to sample code. -- Program the free Express ClickYes (http://www.express-soft.com/mailmate/clickyes.html) tool to start suspended and turn it on only when your program needs to have the buttons clicked automatically." -- Sue Mosher, Outlook MVP Outlook and Exchange solutions at http://www.slipstick.com Author of Microsoft Outlook Programming: Jumpstart for Administrators, Power Users, and Developers http://www.slipstick.com/books/jumpstart.htm END OF QUOTED MATERIAL -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "PeterM" <PeterM(a)discussions.microsoft.com> wrote in message news:DC116E47-C98B-4ED4-9C79-4A3560695D47(a)microsoft.com... > We have some VBA code that generates and automatically sends emails..the > code > looks like... > > Dim mobjoutlook, mobjcurrentmessage > Set mobjoutlook = CreateObject("Outlook.application") > email_form = email_form_name > Set mobjcurrentmessage = mobjoutlook.Createitemfromtemplate(email_form) > send_to = customer.HyperlinkAddress > mobjcurrentmessage.Recipients.Add (send_to) > mobjcurrentmessage.send > > it works great, however...when it executes the .send, we get a warning > from > Outlook that another program is attempting to access Outlook and we have > to > allow the access for 1 minute to 10 minutes. My question is...is there a > way > to eliminate this warning? I've tried docmd.setwarnings false before the > .send and docmd.setwarnings true right after the send, but the message > persists. > > Please help...we need to send emails to many people, (100+) at a time and > it's not feasible to have someone sit there answering the same question > over > and over. > > Thanks in advance for your help! >
From: "Tom Wickerath" <AOS168b AT comcast DOT on 18 Dec 2005 05:16 Hi Peter, In addition to the information quoted by Doug, there are two other options that you might find acceptable: 1.) Fairlogic WorldCast (free for non-commercial use) http://www.fairlogic.com/worldcast/index.shtml 2.) Total Access Emailer by FMS (not free) http://www.fmsinc.com/products/Emailer/index.asp Tom http://www.access.qbuilt.com/html/expert_contributors.html http://www.access.qbuilt.com/html/search.html __________________________________________ "Douglas J. Steele" wrote: Questions regarding the Outlook Security prompt are asked very frequently. The most complete answer has been provided by Outlook MVP Sue Mosher and is as follows: BEGIN QUOTED MATERIAL: "The security dialogs that pop up when an application tries to access certain Outlook properties and methods are designed to inhibit the spread of viruses via Outlook; see http://www.slipstick.com/outlook/esecup.htm#autosec. If you are a standalone user, Outlook provides no way to suppress this behavior. However, you can use a free tool called Express ClickYes (http://www.express-soft.com/mailmate/clickyes.html) to click the security dialog buttons automatically. Beware that this means if a virus tries to send mail using Outlook or gain access to your address book, it will succeed. "If you're the administrator in an Exchange Server environment, you can reduce the impact of the security prompts with administrative tools. See http://www.slipstick.com/outlook/esecup/admin.htm "If it's an application you wrote yourself, you can use one of these approaches to redo the program: -- Use Extended MAPI (see http://www.slipstick.com/dev/mapi.htm) and C++ or Delphi; this is the most secure method and the only one that Microsoft recommendeds. -- Use Redemption (http://www.dimastr.com/redemption/), a third-party COM library that wraps around Extended MAPI but parallels the Outlook Object Model -- Use SendKeys to "click" the buttons on the security dialogs that your application may trigger. See http://www.slipstick.com/outlook/esecup.htm#autosec for a link to sample code. -- Program the free Express ClickYes (http://www.express-soft.com/mailmate/clickyes.html) tool to start suspended and turn it on only when your program needs to have the buttons clicked automatically." -- Sue Mosher, Outlook MVP Outlook and Exchange solutions at http://www.slipstick.com Author of Microsoft Outlook Programming: Jumpstart for Administrators, Power Users, and Developers http://www.slipstick.com/books/jumpstart.htm END OF QUOTED MATERIAL -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) __________________________________________ "PeterM" wrote: We have some VBA code that generates and automatically sends emails..the code looks like... Dim mobjoutlook, mobjcurrentmessage Set mobjoutlook = CreateObject("Outlook.application") email_form = email_form_name Set mobjcurrentmessage = mobjoutlook.Createitemfromtemplate(email_form) send_to = customer.HyperlinkAddress mobjcurrentmessage.Recipients.Add (send_to) mobjcurrentmessage.send it works great, however...when it executes the .send, we get a warning from Outlook that another program is attempting to access Outlook and we have to allow the access for 1 minute to 10 minutes. My question is...is there a way to eliminate this warning? I've tried docmd.setwarnings false before the ..send and docmd.setwarnings true right after the send, but the message persists. Please help...we need to send emails to many people, (100+) at a time and it's not feasible to have someone sit there answering the same question over and over. Thanks in advance for your help!
|
Pages: 1 Prev: networkdays formula in MS access. Next: How can I correct Invalid Argument Error 3001 |