Using SendObject to email

[Sean]

My General Manager has rquested that when certain changes are made to the fields of an application I have created, he receives the information as an email. My approach has been to use the SendMail object in Macros however there are two stumbling blocks:

1. When the macro executes an Outlook warning box pops up with the following message: A program is trying to automatically send email on your behalf. Do you want to allow this? If this is unexpected, it may be a virus and you should choose "No".

2. When the email arrives in Outlook it sits in the Outbox rather than sending.

I need to know if there is some way around these roadblocks so that the process may become completely automated.

Thanks Sean

 

[Klutzz]

I have been encountering some of the same here Sean...I wouldlike to do away with the warning box as well but I have not had the problem with the "outbox' I am looking at the various settings in the mail program (outlook and outlook exp.)
If you dont mind my asking how is your macro triggered for execution, I have mine attached to a checkbox on my data entry form, it works but it is sending the alert via the macro prior to the form info being saved as a recordset to my table...any Ideas there ???

 

[John]

This is a Microsoft warning message to let the user know
his email addresses are being accessed by another program.
Here is part an post from Cheryl Fischer(MVP)

BEGIN QUOTED MATERIAL:

"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 QUOTED MATERIAL:


John

-----Original Message-----
My General Manager has rquested that when certain changes

are made to the fields of an application I have created, he
receives the information as an email. My approach has been
to use the SendMail object in Macros however there are two
stumbling blocks:

1. When the macro executes an Outlook warning box pops up

with the following message: A program is trying to
automatically send email on your behalf. Do you want to
allow this? If this is unexpected, it may be a virus and
you should choose "No".

2. When the email arrives in Outlook it sits in the Outbox rather than sending.

I need to know if there is some way around these

roadblocks so that the process may become completely automated.