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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Automatically Send a notification email once a record is added 0
SendObject in Macro Fails Second Time Through 2
Macro to use information in a cell to locate and send files using outlook 0
Access create a form calling macros 2
macros with a macro 1
send object using a maco--filter report 1
SendObject Macro to multiple Recipients 1
Access 2003 - Basic Macro Help 2

Back
Top