Email

  • Thread starter Thread starter Ginger
  • Start date Start date
G

Ginger

I would like to create a field on a form that contains an
email address. When it is clicked on, it will then send an
email to that address. I know I can use the sendobject in
a macro, but I do not know how to specify in the "to"
field of that macro the name of the field I want to use
for the "to" address.
 
If you want to use a macro, insert the following in the To: property

=[Forms]![MyFormName]![MyEmailControlName]

Do not make the Email field (in the table which is the record source for
your form) a Hyperlink type - it should be a Text field. Also, if you want
the new mail message opened so that you can edit it, be sure to set the Edit
Message property to 'Yes'.
 
Thanks
-----Original Message-----
If you want to use a macro, insert the following in the To: property

=[Forms]![MyFormName]![MyEmailControlName]

Do not make the Email field (in the table which is the record source for
your form) a Hyperlink type - it should be a Text field. Also, if you want
the new mail message opened so that you can edit it, be sure to set the Edit
Message property to 'Yes'.


--

Cheryl Fischer, MVP Microsoft Access



I would like to create a field on a form that contains an
email address. When it is clicked on, it will then send an
email to that address. I know I can use the sendobject in
a macro, but I do not know how to specify in the "to"
field of that macro the name of the field I want to use
for the "to" address.
Click to expand...


.
Click to expand...
 
Back
Top