Getting WSH to run properly via VB Script in an email message

G

Guest

What I need: I need so send an email to someone. When they get the email, and they open it, VB script code fires in the background, opens up WSH, and gets local information from their PC and writes it to a server share

What I have: I have the WSH code written up and it runs fine. If I create a new mail message, go into Design Form mode and add the code in (code is triggered via a Function_Open() command) and then choose From/Run this form, the code runs and copies my local data to the share. Ok, then I address the email to a user and have him/her open the email, but the code refuses to run on his/her PC. I know they have WSH running on their PC. What I am doing wrong? This is driving me crazy. Thanks in advance.

Sam
 
S

Sue Mosher [MVP]

If the form runs code when you use Run This Form in design mode, but doesn't
run code after you have sent or saved an item using the form, you probably
have done something to "one-off" the form. Outlook 2003, Outlook 2002,
Outlook 2000 SP2 and Outlook 2000 or 98 with the Email Security Update will
not run code on one-off forms; see
http://www.slipstick.com/outlook/esecup.htm#formsec for more information on
this issue.

To ensure that a form does not one-off:

-- Make sure the "Send form definition with item" box on the (Properties)
tab of the form is *not* checked. [1]

-- For in-house corporate use with Exchange Server, publish the form to the
Organization Forms library or a public folder's forms library, as
appropriate for your application.

-- For collaboration via the Internet, publish your form to your Personal
Forms library. Save it as an .oft file and send it to other people who need
to use it with instructions to publish it with the same form name that you
used.

Many other things can cause one-off forms. If the above steps don't work on
a new item created with your form, see
http://www.slipstick.com/dev/formpub.htm#oneoff for other possible causes.

[1] Whenever you publish a message form, Outlook will suggest that you may
want to check the "Send form definition with item" box to ensure that the
recipient will have the form, especially if you're sending to someone via
the Internet. In the current Outlook security environment, this suggestion
is obsolete. Ignore it unless your form has no code behind it.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers



Sam said:
What I need: I need so send an email to someone. When they get the email,
and they open it, VB script code fires in the background, opens up WSH, and
gets local information from their PC and writes it to a server share
What I have: I have the WSH code written up and it runs fine. If I create
a new mail message, go into Design Form mode and add the code in (code is
triggered via a Function_Open() command) and then choose From/Run this form,
the code runs and copies my local data to the share. Ok, then I address the
email to a user and have him/her open the email, but the code refuses to run
on his/her PC. I know they have WSH running on their PC. What I am doing
wrong? This is driving me crazy. Thanks in advance.
 

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

Top