Creating HTML string

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to construnct a string for a hyperlink in VBA which will display a
different value from the actual address (string is passed to Outlook mail
message). E.g. the display of the link would say Approve, and not show the
entire address.

I'm building the string in Access, and then sending all the email, subject,
body etc. to Outlook. The constructed string is ApprvLink = "<a href=" &
Chr(34) & "http://www.test.com/development/LOPSummary.aspx" & Chr(34) &
">Approve</a>"

the result in the email body is: <a
href="http://www.test.com/development/LOPSummary.aspx">Approve</a>

I am trying to just have it display Approve, and clicking the link would go
to the address.

If I just send the address
(http://www.test.com/development/LOPSummary.aspx), without the html tags, it
works fine, but the display is not what I want (the full web address).

Am I missing something? Is there a way to accomplish this?

thanks for any assistance,

Tom
 
Hi Tom,

Send me a reproducable sample access application with a zipped package. I
guess you know my email and I would like to reproduce it on my side before
we go further :)

Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!


Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================

This posting is provided "AS IS" with no warranties, and confers no rights.
 
Back
Top