VBA - inserting text as link (email to)

  • Thread starter Thread starter ajliaks
  • Start date Start date
A

ajliaks

Hi,

If I have a text like this, in a userform,

(e-mail address removed)

How can I make it a link (mail to). with subject: "AAAAAA"

Thanks
 
Go to Insert>Hyperlink and modify the Text to Display

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

multiple cells text to text in one cell 3
email layout 1
Import txt file with fixed length from VBA 3
Disallow Continuous String of same Character 1
Send thru different accounts - all show same return address 5
Need Help in cut/paste data from text file to another using excelmacro 2
Replaced text count 4
VBA copy and paste data 2

Back
Top