E-mail addresses storage and click to use.

jam

Registered User.
Local time
Today, 20:29
Joined
May 14, 2009
Messages
42
Hi everyone, thanks for your ongoing support. This flick back to access is really getting my juices going and I'm impressed by some improvements and mostly annoyed my 'improvements' over my beloved Access V2 lol.

Anyway to the problem in hand...
I want to store peoples e-mail addresses in a table and from a form click on the email address and bring up the computers default e-mail client to send that person a message. I have the field set to be a hyperlink and it just try's to open a webpage rather than recognising it as an e-mail address and loading the computers default e-mail client and inserting the email address into the send to field.

I thought that if I had it set as Hyperlink it would recognise the email address and automatically load the default mail client (I'm obviously wrong) lol. I don't need to (at the moment) send mail shots to clients on the database just simply 1 email to 1 person from the email address field held on the database.

Thanks for your continual support!!!!
jam
 
You can use smart tags property of field
 
My version of access (2003) doesn't have an option for smart tags or at least not one I can see. I have followed the Microsoft's troubleshooter to enable smart tags by using the options menu and the option to enable/disable smart tags is missing from the menu. :confused:
 
have you tried using

mailto: email address

as a hyperlink?
 
Where would I put mailto? In the default text section?

Obviously I don't want any users deleting this mail to command or it'll turn into a web link? As always the users will be too lazy to remember to input mailto: xxx@yyy.com
 
Well if you store the email address you can just have it add mailto: in front of it.
 
Awesome.

How would I go about automatically adding mailto to the beginning of the stored e-mail address?

Sorry for being a pain.
 
How are you putting them into the table?
 
Table - Ownertable
OwnerID - autonumber
....
....
....
E-mail address - Hyperlink
Sample data from table...
jam86@hotmail.com
a@a.com
b@b.com


I'm pretty sure this is how I did it back in V2, but obviously it doesn't work now.
 
No I mean how are you inserting them in? Are you typing them in directly or using a form to do it?
 
Yep just typing them in directly into the field.
 
Another alternative is to have the email address as a String and then have a Command Button to do call the email client.

Simon
 

Users who are viewing this thread

Back
Top Bottom