How to I format a Field to enter an e-mail address

[JJordan]

I can change the format of each record, but i want it so the person just enters the e-mail in a form for each new contact and it IS an e-mail address that can be clicked on to generate an e-mail (eventally I will use the e-mail to send out our newsletters and save postage).

 

[DBL]

The email address can be a text field in the table and you can set the format of the field on the form to give you blue letters with an underscore. Here's what you would put on the OnClick event of the field to generate an email. Automatically send out in Outlook Express, not sure if that can be altered:

DoCmd.SendObject acSendNoObject, , , Me.UEmail


UEmail should be the name of your field