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 = "Fake0@email.com"
       .Recipients.Add "fake@email.com"
       .Recipients.Add " fake2@email.com"
       .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