Outlook permission to access ytou remail message.

  • Thread starter Thread starter Kelly
  • Start date Start date
K

Kelly

Hi group, I am using the Office 2000 package and I
developed an Expense template in Excel that many users
access on a shared drive. I created a macro that is
activated by a command button that automatically emails
the expense claim to the Payroll dept. To give you an
idea of the code I used I will include some of it here.

Dim OutApp As Outlook.Application
Dim OutMail As Outlook.MailItem
Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(olMailItem)
With OutMail
'.To = "(e-mail address removed)"
.Recipients.Add "(e-mail address removed)"
.Recipients.Add " (e-mail address removed)"
.BCC = ""
.Subject = "*** My Expense Claim ***"
.Body = " "
.Attachments.Add ActiveWorkbook.FullName

The problem is that we have over two hundred users and
each time the "Email to Payroll" button is pressed Outlook
pops up with a question for the user asking "outlook is
trying to access your email on your behalf do you want to
allow this" there is a check box that says allow
for "Dropdown number of minutes" and YES / NO buttons.

Then after you select YES it asks a second time (this time
with out the check box option) Sometimes these pop up
questions are not in front of the Excel sheet and then the
user thinks the system just locked up and does not know
how to proceed.

Questions
1. Why is Outlook asking TWICE if it is allowed to
access your email?
2. Is there a way that we can set Outlook so that it
will recognize this template as a legit template and allow
it to proceed without the questions, Or with only one
question?
3. Is there a way I can ensure that the pop-up window
is always pushed to the Front View to avoid confusing the
ends users?

Any and all help appreciated...

Kelly
 
To avoid getting the popup message, you can digitally sign the macro so
outlook knows the macro is safe.
If you have 200 users accessing this template, I would go the route of
setting up a digital signature.
 
No, digitally signing a VBA macro project has no effect on the security
prompts. See See http://www.outlookcode.com/d/sec.htm for your options with
regard to the "object model guard" security in Outlook 2000 SP2 and later
versions. Redemption is highly recommended.
--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
Back
Top