Email

[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.

 

[Cheryl Fischer]

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'.

 

[ginger]

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.

.