Discussion Locked

Access 97 link to Outlook New Mail

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am creating a customer database at the moment where I would like a user to be able to double click on an e-mail address to automatically open up a new mail message via Microsoft Outlook (both 97 and 2000) with that e-mail in the 'To' field. Does anybody know how I can program this function either in the expression builder, macro or event procedure.

4 replies

by sergey kovzik

There is Hyperlink data type in Access. You can enter mailto:user@domain.com as value and this field become clickable with mouse. Access recognises also http://, ftp, news, nntp and other prefixes for URLs in this kind of data.

Sincerely, SergeyBrainbench MVP for Win98 Administration

This discussion is closed to new replies.