creating hyperlinks with display text in VBA

[SUZYQ]

I have a table that has a hyperlink field with the web address I need
and a text field with the title that I want to see.

Using VBA, I want to email out this list of hyperlinks, but I want the
user to see the title instead of the web address.

For example, if the web address is www.pbs.org, I want the user to get
an email with a hyperlink in the body of the email that says "Great
Shows for Kids" and if they click on it, the web browser opens to PBS.

I know how to create the email part, but I can't figure out how,
though VBA, to identify a variable to hold this appropriate
information to feed into the body of the email. I found a lot of
information about using hyperlinks with objects on a form, but I don't
have this scenerio.

Please help.

Thanks.

 

[Daniel]

I'm assuming that you set up the email content to be in HTML format thus you
need to follow HTML synthax

<a href="URL" target="_blank">TExtDisplayedToUser</a>

So you'll have to set up in your email routine code to build this type of
statement in the body, such as:

"<a href=""" & Me.URL & """ target="""_blank""">" & Me.Title & "</a>"

Daniel

 

[SUZYQ]

I'm assuming that you set up the email content to be in HTML format thus you
need to follow HTML synthax

<a href="URL" target="_blank">TExtDisplayedToUser</a>

So you'll have to set up in your email routine code to build this type of
statement in the body, such as:

"<a href=""" & Me.URL & """ target="""_blank""">" & Me.Title & "</a>"

Daniel










- Show quoted text -

Thanks. That makes sense. Unfortunately, I'm sending the emails via
Lotus Notes and can't figure out how to make the format HTML. I
believe the code I has sends the body in Rich Text. Thoughts?