DeanMcC
02-25-2009, 12:50 PM
I have a vba macro which creates an email with an embedded hyperlink. The only issue i have is that the url for the hyperlink is being truncated. I am using a variable to define the url and it contains a string like this:
M:\ITDevelopment\Common\is\IT Clinical Applications\IP Clinical\SPR Requests\SPR12345 Test Project\SPR12345 Checklist.doc
The above value is contained in the variable NewCheckList. But when I open the email, the url is truncated to this:
M:\ITDevelopment\Common\is\IT
Here is part of the code.
.HTMLBody = "<body><font size=2 face=Arial>Patty,<br><br>" & _
"For your review and approval to begin QA Testing.<br><br>" & _
"<A HRef=" & NewCheckList & ">" & SPRNumber & " " & SPRDescription & "</a><br><br><br>" & _
"<font color=Blue><b>Thank You,<br><br>" & _
"developers name<br>" & _
"Lead Programmer/Analyst<br>" & _
"(XXX) XXX-XXXX</b></font></font><br><br><br>" & _
"<font size=1 face=Arial color=Blue>" & ConfidentialityNotice & "</font></body>"
I have debugged the code to confirm the contents of the variable.
Any ideas what I can do to correct this?
Thank you,
Dean
M:\ITDevelopment\Common\is\IT Clinical Applications\IP Clinical\SPR Requests\SPR12345 Test Project\SPR12345 Checklist.doc
The above value is contained in the variable NewCheckList. But when I open the email, the url is truncated to this:
M:\ITDevelopment\Common\is\IT
Here is part of the code.
.HTMLBody = "<body><font size=2 face=Arial>Patty,<br><br>" & _
"For your review and approval to begin QA Testing.<br><br>" & _
"<A HRef=" & NewCheckList & ">" & SPRNumber & " " & SPRDescription & "</a><br><br><br>" & _
"<font color=Blue><b>Thank You,<br><br>" & _
"developers name<br>" & _
"Lead Programmer/Analyst<br>" & _
"(XXX) XXX-XXXX</b></font></font><br><br><br>" & _
"<font size=1 face=Arial color=Blue>" & ConfidentialityNotice & "</font></body>"
I have debugged the code to confirm the contents of the variable.
Any ideas what I can do to correct this?
Thank you,
Dean