Create a form for macro data entry

[Bassel]

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

 

[Steve Schapel]

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]