Automatically enter E-mail address in To: diesl of SendObject Mac

G

Guest

I would like the SendObject Macro to automatically enter the value of a field
in a form that call the SendObject Macro into the To: field of the macro.
The data for the To: field will be pulled from the Forms]![Work
RequisitionsBackup]![Therapist] field of the open form (which has a button
that activates the SendObject macro). I have tried and failed with these;
"'" &Forms]![Work RequisitionsBackup]![Therapist] "'"
"'" + Forms]![Work RequisitionsBackup]![Therapist] + "'"
"Forms]![Work RequisitionsBackup]![Therapist]"
Forms]![Work RequisitionsBackup]![Therapist]

Is this possible?

Thanks
Andy
 
G

Guest

Thanks Steve, that worked great!

Steve Schapel said:
Andy,

Enter it like this:
=[Therapist]

--
Steve Schapel, Microsoft Access MVP
I would like the SendObject Macro to automatically enter the value of a field
in a form that call the SendObject Macro into the To: field of the macro.
The data for the To: field will be pulled from the Forms]![Work
RequisitionsBackup]![Therapist] field of the open form (which has a button
that activates the SendObject macro). I have tried and failed with these;
"'" &Forms]![Work RequisitionsBackup]![Therapist] "'"
"'" + Forms]![Work RequisitionsBackup]![Therapist] + "'"
"Forms]![Work RequisitionsBackup]![Therapist]"
Forms]![Work RequisitionsBackup]![Therapist]

Is this possible?

Thanks
Andy
Click to expand...
Click to expand...
 

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

My "Condition" String is too long 5
Sending E-Mails Using Macros - Populate To and CC 2
Using Query Field to name SendObject file 3
Send an e-mail from the e-mail address in a Form 1
SendObject Macro to multiple Recipients 1
Access 2007 Macros - SendObject action, Message Text action argume 8
Mail Pop-up Message 6
timestamp in subject line of sendobject 1

Top