Cannot form email hyperlink correctly with variables.

[Dave Lagergren]

I am trying to formulate a string that is used as a hyperlink in an email
sent out by CDO. I can get the entire string put together correctly except
for the last set of quote marks. Here is what works best:

strOriginalMessage = "Dear " & NewProcessor & vbcrlf&_
"Please process this order ASAP. Follow this link for order:
http://wirelessmgt.com/logon/order_display.asp?OrderNumber=" & chr(34) &
Request.Form("OrderNumber") & """"

When this is sent out in an email it has the final set of quotes but they
are not part of the hyperlink. It looks like:
http://wirelessmgt.com/logon/order_display.asp?OrderNumber="24"
--------------------------------------------------------------------

If I cut and paste the link it works, but not if I click on it. Does anyone
know what I am doing wrong?

By the way I really like CDO for sending emails from web pages. I can send
multiple emails from one page. I use them from my confirmation page.

 

[Dave Lagergren]

Update:

When I open the email in Outlook at home the ending number with it's quotes
("32") after the = is not part of the hyperlink.

When I open the email on my office computer only the last " is not part of
the hyperlink. Is this possibly an Outlook problem?

What ever is wrong I need to get it corrected or we won't get any orders
processed.

Dave

 

[Stefan B Rusynko]

Try
strOriginalMessage = "Dear " & NewProcessor & vbcrlf &_
"Please process this order ASAP. Follow this link for order: http://wirelessmgt.com/logon/order_display.asp?OrderNumber=" &
Request.Form("OrderNumber")

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


|I am trying to formulate a string that is used as a hyperlink in an email
| sent out by CDO. I can get the entire string put together correctly except
| for the last set of quote marks. Here is what works best:
|
| strOriginalMessage = "Dear " & NewProcessor & vbcrlf&_
| "Please process this order ASAP. Follow this link for order:
| http://wirelessmgt.com/logon/order_display.asp?OrderNumber=" & chr(34) &
| Request.Form("OrderNumber") & """"
|
| When this is sent out in an email it has the final set of quotes but they
| are not part of the hyperlink. It looks like:
| http://wirelessmgt.com/logon/order_display.asp?OrderNumber="24"
| --------------------------------------------------------------------
|
| If I cut and paste the link it works, but not if I click on it. Does anyone
| know what I am doing wrong?
|
| By the way I really like CDO for sending emails from web pages. I can send
| multiple emails from one page. I use them from my confirmation page.
|
| --
| Dave Lagergren
| Manager - Data Applications
| Wireless Management, Inc
| Specializing in cellular wireless applications

 

[Thomas A. Rowe]

You don't put the quotes in querystrings.

Follow Stefan example

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

http://www.Ecom-Data.com
==============================================