Add hyperlink to Outlook mail with variable text

[askpcguy]

Hi everyone,

I'm trying to insert a hyperlink into a new Outlook email item where the hyperlink contains a variable, the variable is a Ticket ID the user enters in a Textbox on a Userform.

I've only got code working to open a new Outlook email then insert the text from the userform. Beyond that I've been trying a few things but nothing has worked. Any help is appreciated!

Please Login or Register  to view this content.

[AlphaFrog]

Try something like this...

Please Login or Register  to view this content.

[askpcguy]

That's darn close AlphaFrog! Is there a way to make Text To Display the TextBox1.Value?

I've got this thus far.

Please Login or Register  to view this content.

[AlphaFrog]

Please Login or Register  to view this content.

[askpcguy]

Ah, the spaces around the TextBox1.Value kept driving me insane. I finally figured out I was trying to concatenate a string with a variable value, but that works great AlphaFrog. I can't +rep so if you've got a paypal email you can PM me, I insist lunch is on me.

[AlphaFrog]

You were so close on your attempt, but you get it now. It's just about concatenating a text string of the the HTML code with the Textbox.value.

Glad it worked; pay it forward. It would be nice to leave a note on how you eventually paid, but it's not required.

[askpcguy]

How about this, say someone wants to use a variable for the http:// page within the .HTMLBody object, here's what I did.

Please Login or Register  to view this content.