adding hyperlinks to query results

  • Thread starter Thread starter tgwarrior
  • Start date Start date
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
(e-mail address removed)
 
Use a Calculated Field in your Query:

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

HTH
Van T. Dinh
MVP (Access)
 
Back
Top