A Button to Open a Macro in Edit View

Macro Hunter,

This is not a good idea. Sorry.

You need to have a form, with either a textbox where the user enters the
email address of the intended recipient, or a combobox where the user
selects the intended recipient. And then you need to refer to this
textbox/combobox in the macro. If, as I am guessing, your macro uses the
SendObject action, then the 'To' argument would look like this:
=[NameOfYourTextboxOrCombobox]
(this assumes the button to run the macro is on the same form)

Steve Schapel, Microsoft Access MVP


"Macro Hunter" <Macro wrote in message
news:

I would like to make a button that opens up a Macro that is set up for
automatic e-mail. I would like to have this option for novice users to be
able to change who will receive the e-mails. If the button could pull up
the
existing macro in edit view, I believe with a little instruction this
would
work.