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
 
Ad

Advertisements

Ad

Advertisements

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
 

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

Top