adding hyperlinks to query results

T

tgwarrior

I have two fields, one with a name, one with an email
address. (Not all
recordsets include an email address for the person's name.)

Ideally, I'd like to have the query add
a "mailto:<address>" HTML tag for
every name that also has an email address. Can that be
done?

Thank you for your assistance!

michael munson
[email protected]
 
V

Van T. Dinh

Use a Calculated Field in your Query:

MTAdd: IIf(IsNull([Address]), "",
"MailTo:" & [Address])

HTH
Van T. Dinh
MVP (Access)
 
Top