Hyperlink in e-mail with VBA script

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How to create hyperlink in e-mail with VBA script? ...
I want sent e-mail with VBA script to create shortcut on desktop.
When other user open this e-mail and click on hyperlink, automaticaly will
be create shortcut to network place with one aplication.

Example:
I need to create shortcut on desktop for \\apps\data\database.mdb

Thanks!
 
I don't understand what you're trying to do. Putting a hyperlink in an email message doesn't have anything to do with creating a shortcut on the desktop, which is not something that can be done in an email message.
 
I want sent some users e-mail with code for automation to create shortcut on
her desktop. Problem is when i sent hyperlink to some people, then must
create shortcut... but they don't know and call admin.
I need macro for this.
Thanks!
 
An email message doesn't run macros, and it can't run VBScript code to do that. The only way you could get it to work is with a custom Outlook form published to the Exchange server's Organizational Forms library, with a button on it to run a script behind the form that creates a shortcut.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54
 
I don't have any code like that, as it's not at all related to Outlook. I'm sure some would turn up on a search at Google or your favorite search engine. The only thing that would be Outlook-related is what you want the user to do to run the code -- open the item or click a button on the form surface.

But it will be a futile effort if you can't meet the requirement of publishing to the Organizational Forms library. FIrst things, first.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54
 
Again, the prerequisite for doing this with Outlook is being able to publish a custom form to the Organizational Forms library. Have you confirmed that is possible?

The article at http://msdn2.microsoft.com/en-us/library/xsy6k3ys(VS.85).aspx explains how to use the CreateShortcut method of Windows Script Host to create a shortcut.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54
 
I'm realy sorry if i've misunderstood the website behind the link you gave,

but i read it as it is a way to add a hyperlink to you desktop!

I like to add a link to a website, by VBA code. Wich website I like to
choose from a radiobutton on a form

Regards, Dirk
 
but i read it as it is a way to add a hyperlink to you desktop!

Exactly. That's what you want to do, isn't it? You wrote: "I want sent e-mail ... to create shortcut on desktop."
I like to add a link to a website, by VBA code.
Click to expand...

VBA has nothing to do with Outlook forms, which run VBScript code.
Wich website I like to choose from a radiobutton on a form
Click to expand...

To do this, requires code behind a published custom form. As I've explained twice already, achieving your goal means that you need to be able to publish the form to the Organizational Forms library on your organization's Exchange Server. Until you can confirm that you have permission to do that, your project cannot go forward.
 
To clarify, the WSH article demonstrates how to create a shortcut *on* the desktop, not *to* the desktop.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


Sue Mosher said:
but i read it as it is a way to add a hyperlink to you desktop!
Click to expand...

Exactly. That's what you want to do, isn't it? You wrote: "I want sent e-mail ... to create shortcut on desktop."
I like to add a link to a website, by VBA code.
Click to expand...

VBA has nothing to do with Outlook forms, which run VBScript code.
Wich website I like to choose from a radiobutton on a form
Click to expand...

To do this, requires code behind a published custom form. As I've explained twice already, achieving your goal means that you need to be able to publish the form to the Organizational Forms library on your organization's Exchange Server. Until you can confirm that you have permission to do that, your project cannot go forward.
 
Back
Top