Improving Emails through Access

  • Thread starter Thread starter Angela Runde
  • Start date Start date
A

Angela Runde

We have a wonderful database to send e-mails through
outlook. Now we were wondering if the following were
possible and after some research we are about to say no:

1. Can you transfer the input mask on your fields to the
e-mail? For example the phone number. We have it in the
table and query, and it is storing it with the mask
instead of just the numbers, but we can't get it to show.

2. Can you ever get that outlook message to go away that
you need to click yes before it will send your emails??
I know it is there for a reason and we thought
setmessages would work, but of course not.

3. Also, can you open outlook through the VB code...in
C++ you can use your system messages to open other
programs, but we aren't having the best of luck through
VB.

Thank you for any help you can give us, we appreciate
your time. Have a great weekend!
 
Angela,

In regard to your Question 2: 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."

END OF QUOTED MATERIAL

I have been pleased with Express ClickYes and have used the code they supply
at their website plus some tweaks of my own to turn the utility on, send
emails and then turn the utility off. It does not make the Security Prompt
disappear but it will click the 'Yes' button for you.

hth,
 
Back
Top