Results 1 to 2 of 2

Thread: How to add hyperlink to a variable

  1. #1

    Thread Starter
    New Member
    Join Date
    Dec 2005
    Posts
    5

    How to add hyperlink to a variable

    Dear all,

    I have a macro that sends an e-mail at the end of the macro for information.

    I have a string that has the address called FolderName(everday this adress
    changes so it must be a variable)

    And i have a body in e-mail that has the writing;

    ...
    .
    You can click the below link to access the folder;

    FolderName

    -----------

    But i don't want them only to see the address. What i want is to have a
    link- when they click on it, go to the address. But don't know how to do
    The code;

    myItem.Body = myItem.Body + "Hello"
    myItem.Body = myItem.Body + vbNewLine
    myItem.Body = myItem.Body + vbNewLine
    myItem.Body = myItem.Body + "To see the " & DateString & " dated
    program, please look at the address: " & FolderName &


    But i want to alsa give a link to FolderName.

    Thanks..

  2. #2

    Thread Starter
    New Member
    Join Date
    Dec 2005
    Posts
    5

    Re: How to add hyperlink to a variable

    What i want to have is a writing like that in body;

    Please Click here to access the files.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width