populate To: section of email from field on form

[Guest]

I want use "sendto" macro to attached a report onto email , this is launched
from a form but i cannot get the macro to populate the To: section with an
email address on that form. Any ideas , i saw a simple bit of code ages ago
but cant find it now.

thx tat

 

[Allen Browne]

Assuming the email address is in a text box named Email, this code should do
it:

DoCmd.SendObject acSendNoObject,,, Me.,,,"Hello", "Here's your email"