additional help with a module

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

Previously, I posted a question regarding a module that John Nurick was kind
enough to help me with, regarding sending email from a recordset.

The module is now working exactly as I wanted it to...thanks again, John.

My question now:
Is it possible to set things up so that I can run the module from a command
button on the form, instead of having to open the module, then use the run
command to make it run?

Oh, when it runs, I get a message from Outlook telling me its trying to run
and am I sure? Is there any way to eliminate that, so it will run without
interruption?

Thanks

Steve
 
Steve,

You're not running the module, but a procedure (Sub or Function) in it.
Just set up the button so it calls that procedure in its Click event
procedure.

As for the Outlook message, it was introduced a few years ago as an
Outlook security measure and there's no simple way to disable it. See
http://www.slipstick.com/outlook/esecup.htm#autosec for background
information and options.
 
Thanks again John...you have been a really big help

Steve

Steve,

You're not running the module, but a procedure (Sub or Function) in it.
Just set up the button so it calls that procedure in its Click event
procedure.

As for the Outlook message, it was introduced a few years ago as an
Outlook security measure and there's no simple way to disable it. See
http://www.slipstick.com/outlook/esecup.htm#autosec for background
information and options.
 
Back
Top