Outlook permission to access ytou remail message.

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

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.

"Kelly" <anonymous@discussions.microsoft.com> wrote in message
news:c47601c47a4a$1f61acc0$a301280a@phx.gbl...
> 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
>

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
http://www.outlookcode.com/jumpstart.aspx


"Brian S." <duvallbrian111@verizon.net> wrote in message
news:uzFGTIleEHA.3928@TK2MSFTNGP11.phx.gbl...
> 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.
>
> "Kelly" <anonymous@discussions.microsoft.com> wrote in message
> news:c47601c47a4a$1f61acc0$a301280a@phx.gbl...
> > 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
> >
>
>