populate To: section of email from field on form

D

david tat

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
 
A

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"
 
Top