refer to field in form to get email address when sending object

[Guest]

I am trying to develop a database that will make it easier to track notices
that we send to our users. As part of the process, I have created a form for
entering the information that we are sending, and a report that will just
show the information I have just entered for that user.
Now, I want to put a command button, using a macro, that I can press to send
the information to the user. I have created the macro, but when I try to use
it to send the object I just get [forms]![first_notice]![EMAIL_ADDRESS] in
the To: field, instead of the actual address. How would I change the
function to actually show the email address instead of showing the fuction?

 

[Steve Schapel]

Beth,

In the To argument of the SendObject action in your macro, put a = in
front...
=[Forms]![first_notice]![EMAIL_ADDRESS]

 

[Guest]

Thank you!
I can't believe it was so easy! Now I feel dumb.

Beth,

In the To argument of the SendObject action in your macro, put a = in
front...
=[Forms]![first_notice]![EMAIL_ADDRESS]

--
Steve Schapel, Microsoft Access MVP

I am trying to develop a database that will make it easier to track notices
that we send to our users. As part of the process, I have created a form for
entering the information that we are sending, and a report that will just
show the information I have just entered for that user.
Now, I want to put a command button, using a macro, that I can press to send
the information to the user. I have created the macro, but when I try to use
it to send the object I just get [forms]![first_notice]![EMAIL_ADDRESS] in
the To: field, instead of the actual address. How would I change the
function to actually show the email address instead of showing the fuction?

 

[Steve Schapel]

I know how you feel, Beth. Happens to me quite often.