Hyperlink issues in query

[RonMcIntire]

All:

I have a query output with names and email addresses. My goal is to send the data to Outlook Express preferably not as an attachment.

Does anyone know how to send the query output to IE with the email addresses hyperlinked so the recipient of the email can open an email by clicking on the hyperlink?

When I view the hyperlinked text box in a report, the object includes the URL. Example: JoeBlow@yahoo.com#

http://JoeBlow.com#

Thanks.

 

[PHV]

Have a look at the HyperlinkPart function.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886