How to remove the single quotes (apostrophes) around a hyperlink address.

[Richard Hollenbeck]

I have an email field and a command button to send email. The
problem is that when the email program opens up there are
apostrophes around the email address that I have to manually
remove before sending the email. My code is very simple. I
can't understand why the apostrophes are put there but the
addresses won't work until they are stipped of the apostrophes.
Here's my code:

Private Sub cmdEmail_Click()
If len(txtEmail) > 0 Then
cmdEmail.HyperlinkAddress = "mailto:'" & txtEmail & "'"
End if
End Sub

Is there another way to re-write this that won't produce the
single quotes?

Thanks.

Rich Hollenbeck

[Tom van Stiphout]

On Thu, 03 Mar 2005 16:37:26 GMT, "Richard Hollenbeck"
<ri****************@verizon.net> wrote:

The "Replace" function is great for taking out unwanted characters.
Check with your help file.

-Tom.

I have an email field and a command button to send email. The
problem is that when the email program opens up there are
apostrophes around the email address that I have to manually
remove before sending the email. My code is very simple. I
can't understand why the apostrophes are put there but the
addresses won't work until they are stipped of the apostrophes.
Here's my code:

Private Sub cmdEmail_Click()
If len(txtEmail) > 0 Then
cmdEmail.HyperlinkAddress = "mailto:'" & txtEmail & "'"
End if
End Sub

Is there another way to re-write this that won't produce the
single quotes?

Thanks.

Rich Hollenbeck

[Rog]

try: cmdEmail.HyperlinkAddress = "mailto:" & txtEmail

[Richard Hollenbeck]

"Rog" <de********@state.gov> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...

try: cmdEmail.HyperlinkAddress = "mailto:" & txtEmail

Yes! That did it. Thank you very much.