Sending Report via Outlook Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I am trying to get a report to be sent automatically via outlook from Access97. I'm using DoCmd.SendObject. Right after that starts I get a messagebox that says "a program is trying to automatically send email on your behalf." After about 5 seconds the yes button is highlighted. I can manually hit the left arrow (no is the default) and then enter to get it to go. I want to use code so this process can be done automatically. I've tried the on timer and lost focus events. Once I start the SendObjects command nothing else seems to get control.

Thanks in advance!
Jerry
 
It is Outlook Security confirming that you actually want
to send the e-mail and not some virus / worm.

See Tony Toews article on e-mail / e-mail security:

<http://www.granite.ab.ca/access/email.htm>

HTH
Van T. Dinh
MVP (Access)


-----Original Message-----
Hi,

I am trying to get a report to be sent automatically via
Click to expand...
outlook from Access97. I'm using DoCmd.SendObject. Right
after that starts I get a messagebox that says "a program
is trying to automatically send email on your behalf."
After about 5 seconds the yes button is highlighted. I can
manually hit the left arrow (no is the default) and then
enter to get it to go. I want to use code so this process
can be done automatically. I've tried the on timer and
lost focus events. Once I start the SendObjects command
nothing else seems to get control.
 
Back
Top