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

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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...
 
Back
Top