Email field Hyperlink type

[Song Su]

Access 2003

I have a field 'email' with hyperlink type. On the form, click the field,
outlook does not start unless email field start with mailto:

User does not remember to type mailto: before the email. Beside, display
mailto: does not look good.

Any way to get around of this?

 

[Stockwell43]

Are you just looking to open a blank email? If so, just use the send object
macro and place a button on the form and in the on click event of the button
select the macro.

 

[Song Su]

Yes, when click the email field, I just want outlook to open a new mail and
email address automatically in. I'm not sure how Macro works.
Can you help? Thanks.

 

[Stockwell43]

Hi Song,

The Macro is very easy and you can put in an email address that will
automatically fill in when the email opens. However, let me ask you one
question:

Do you need more than more email address or are you sending to the same
place over again. If more than one and you will be sending to multiple
people, there is way to do it in a DLookup table but I am not sure how to do
it. Some of these folks are very good with that and can help you better than
me.

For the Macro: Open you database and in the Objects column select Macro.
Then from the Action field select SendObject. Go down to the bottom and fill
in the information needed then name it and save it. On your form, create a
command button but don't go through the wizard just place the button on your
form and click cancel on the wizard. Open the buttons properties and in the
Onclick event, open the drop down and select the macro you just created and
the close out of properties and close the form to save it. Re-open the form
and test the button and it should open a new email with the email address you
entered when creating the macro. If you need more help, please let me know.