Desktop

Ask something
Discussion Locked

Email mask in Access 97

0 helpful
1 reply

by josephjames10

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am developing a MS Access 97 database and I need to create a fields that stores email addresses in email format (name@someone). Once clicked on, I would like the field to activiate my email client (Outlook98) and allow me to send an email.

1 reply

by foehammer

You could use VBA to start outlook like this. Change the path and email address accordingly.

"c:\progra~1\micros~1\office\outlook.exe" -c IPM.Note /m "someone@somewhere.com"

A much neater solution would be to change the email field data type to hyperlink, and store email addresses formatted as 'mailto:someone@somewhere.com'. When you click the link, whatever mail client is the default application as defined by Internet Explorer will be fired up, like it is when you click a mail link in a web page.

This discussion is closed to new replies.