insert email address from current record field

[lotarugg]

Hi,

I have this code

DoCmd.SendObject _
, _
, _
, _
emailaddress@domain.org, _
, _
, _
"This is the subject", _
"This is the message to you", _


This is triggered on a button press on a form. The email needs to go to a person on the particular record currently displayed on the form. Is it possible to switch focus to the field and use the email address in that field. I'm guessing it is, but my coding is really poor

Cheers

 

[pbaldy]

Instead of the address try

Me.EmailAddressTextboxName

 

[lotarugg]

It worked - you star!

Thanks very much

 

[pbaldy]

No problemo!