Create a form for macro data entry

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

Guest

Hello
I have a mcaro that sends a query result as an email attachment. It is
working fine.

Is there is a possible way to allow the user to use a form to set the To and
CC fields of the Send macro without using macro design.
Thus the user will only change these two fields in the macro.

Beat reagrds
 
Bassel,

If you have an unbound textbox on your form, where the user can enter
the email address, then I think it will work if you set the To argument
in the macro to the equivalent of:
=[Forms]![NameOfYourForm]![NameOfTextbox]
 
Back
Top