How do I create a field that stores emails in Access and makes a l

V

Vika

Hello,

I am going crazy with Access filed data types.

I need to store and update data that contains, among the rest, person's
email address. There are nearly 1000 records of people I do not now and have
no intention to store their mails in my address book, only in access database.

The question is - how do I make it to be seen in form or report as a
hyperlink that opens my mail program and creates a message, like WORD does?

I tried to set the field as hyperlink, but it goes opening web page with an
email address, and this is not what I need. Even writing "mailto:" before the
address does not help.

I would be very grateful for the help.

Thank you
 
R

Rick Brandt

Vika said:
Hello,

I am going crazy with Access filed data types.

I need to store and update data that contains, among the rest, person's
email address. There are nearly 1000 records of people I do not now and have
no intention to store their mails in my address book, only in access database.

The question is - how do I make it to be seen in form or report as a
hyperlink that opens my mail program and creates a message, like WORD does?

I tried to set the field as hyperlink, but it goes opening web page with an
email address, and this is not what I need. Even writing "mailto:" before the
address does not help.

I would be very grateful for the help.
Click to expand...

Just make it a text field and on your form format it to blue with an underline.
In the HyperlinkSubAdress property of the TextBox enter " ". That will give you
the pointing hand cursor when you hover over it. Finally, call the SendObject
method in the On-Click event using the value in the TextBox for the Recipient
argument.
 
Top