Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook - Using Forms (http://www.outlookbanter.com/outlook-using-forms/)
-   -   Script only runs on my PC (http://www.outlookbanter.com/outlook-using-forms/95470-script-only-runs-my-pc.html)

Delnang September 30th 09 02:13 PM

Script only runs on my PC
 
I have code behind a command button:
Example:

Item.Body = Item.Body & vbCrLf & "new stuff"

and when I select the command button it works on my PC. When I send the
email, and the recipient clicks the button, nothing happens.

How can I make it so the button work so that if one were to get the form
from the Org. Library, the command buttons run the code?

Thanks,
Angie


Sue Mosher [MVP][_3_] September 30th 09 03:43 PM

Script only runs on my PC
 
The form must be published to the Organizational Forms library with the
"send form definition with item" box on the (Properties) page in the
designer unchecked.

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


"Delnang" wrote in message
...
I have code behind a command button:
Example:

Item.Body = Item.Body & vbCrLf & "new stuff"

and when I select the command button it works on my PC. When I send the
email, and the recipient clicks the button, nothing happens.

How can I make it so the button work so that if one were to get the form
from the Org. Library, the command buttons run the code?

Thanks,
Angie




Delnang September 30th 09 05:06 PM

Script only runs on my PC
 
Yes, that worked like a charm. I knew it would be easy.

Two addtional questions:
1. Is there a way to add an =now() type statement to this so that one would
know when the text was added to an email?

2. Is there a way to surpress automatic signatures in an Outlook form?

Thanks,
Angie

"Sue Mosher [MVP]" wrote:

The form must be published to the Organizational Forms library with the
"send form definition with item" box on the (Properties) page in the
designer unchecked.

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


"Delnang" wrote in message
...
I have code behind a command button:
Example:

Item.Body = Item.Body & vbCrLf & "new stuff"

and when I select the command button it works on my PC. When I send the
email, and the recipient clicks the button, nothing happens.

How can I make it so the button work so that if one were to get the form
from the Org. Library, the command buttons run the code?

Thanks,
Angie





Sue Mosher [MVP][_3_] September 30th 09 05:33 PM

Script only runs on my PC
 
1) Yes, Now() is the correct function. Concatenate with to your existing
expression used to set Item.Body.

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


"Delnang" wrote in message
...
Yes, that worked like a charm. I knew it would be easy.

Two addtional questions:
1. Is there a way to add an =now() type statement to this so that one
would
know when the text was added to an email?

2. Is there a way to surpress automatic signatures in an Outlook form?

Thanks,
Angie

"Sue Mosher [MVP]" wrote:

The form must be published to the Organizational Forms library with the
"send form definition with item" box on the (Properties) page in the
designer unchecked.

"Delnang" wrote in message
...
I have code behind a command button:
Example:

Item.Body = Item.Body & vbCrLf & "new stuff"

and when I select the command button it works on my PC. When I send
the
email, and the recipient clicks the button, nothing happens.

How can I make it so the button work so that if one were to get the
form
from the Org. Library, the command buttons run the code?

Thanks,
Angie




Delnang September 30th 09 05:48 PM

Script only runs on my PC
 
Thank you! What great knowledge.

1) What would the code look like? I am not very well versed. I get
confused as to where () and "" go.
Item.Body = Item.Body & vbCrLf & "concat(=now(),"new stuff")"
??? something like that?

2) Outlook 2003 SP3 for questions: Is there a way to surpress automatic
signatures in an Outlook form?

Thank you,
Angie

"Sue Mosher [MVP]" wrote:

1) Yes, Now() is the correct function. Concatenate with to your existing
expression used to set Item.Body.

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


"Delnang" wrote in message
...
Yes, that worked like a charm. I knew it would be easy.

Two addtional questions:
1. Is there a way to add an =now() type statement to this so that one
would
know when the text was added to an email?

2. Is there a way to surpress automatic signatures in an Outlook form?

Thanks,
Angie

"Sue Mosher [MVP]" wrote:

The form must be published to the Organizational Forms library with the
"send form definition with item" box on the (Properties) page in the
designer unchecked.

"Delnang" wrote in message
...
I have code behind a command button:
Example:

Item.Body = Item.Body & vbCrLf & "new stuff"

and when I select the command button it works on my PC. When I send
the
email, and the recipient clicks the button, nothing happens.

How can I make it so the button work so that if one were to get the
form
from the Org. Library, the command buttons run the code?

Thanks,
Angie





Sue Mosher [MVP][_3_] September 30th 09 06:00 PM

Script only runs on my PC
 
1) Item.Body = Item.Body & vbCrLf & Now()

2) http://support.microsoft.com/?id=840393

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


"Delnang" wrote in message
...
Thank you! What great knowledge.

1) What would the code look like? I am not very well versed. I get
confused as to where () and "" go.
& "concat(=now(),"new stuff")"
??? something like that?

2) Outlook 2003 SP3 for questions: Is there a way to surpress automatic
signatures in an Outlook form?

Thank you,
Angie

"Sue Mosher [MVP]" wrote:

1) Yes, Now() is the correct function. Concatenate with to your existing
expression used to set Item.Body.

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


"Delnang" wrote in message
...
Yes, that worked like a charm. I knew it would be easy.

Two addtional questions:
1. Is there a way to add an =now() type statement to this so that one
would
know when the text was added to an email?

2. Is there a way to surpress automatic signatures in an Outlook form?

Thanks,
Angie

"Sue Mosher [MVP]" wrote:

The form must be published to the Organizational Forms library with
the
"send form definition with item" box on the (Properties) page in the
designer unchecked.

"Delnang" wrote in message
...
I have code behind a command button:
Example:

Item.Body = Item.Body & vbCrLf & "new stuff"

and when I select the command button it works on my PC. When I send
the
email, and the recipient clicks the button, nothing happens.

How can I make it so the button work so that if one were to get the
form
from the Org. Library, the command buttons run the code?

Thanks,
Angie







Delnang September 30th 09 06:35 PM

Script only runs on my PC
 
Again, Thank you!

One last question? Approx. 95% of our users have signatures. How do you go
about getting that custom code to appear above one's signature. Right now,
it is appearing below it.

Thanks,
Angie

"Sue Mosher [MVP]" wrote:

1) Item.Body = Item.Body & vbCrLf & Now()

2) http://support.microsoft.com/?id=840393

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


"Delnang" wrote in message
...
Thank you! What great knowledge.

1) What would the code look like? I am not very well versed. I get
confused as to where () and "" go.
& "concat(=now(),"new stuff")"
??? something like that?

2) Outlook 2003 SP3 for questions: Is there a way to surpress automatic
signatures in an Outlook form?

Thank you,
Angie

"Sue Mosher [MVP]" wrote:

1) Yes, Now() is the correct function. Concatenate with to your existing
expression used to set Item.Body.

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


"Delnang" wrote in message
...
Yes, that worked like a charm. I knew it would be easy.

Two addtional questions:
1. Is there a way to add an =now() type statement to this so that one
would
know when the text was added to an email?

2. Is there a way to surpress automatic signatures in an Outlook form?

Thanks,
Angie

"Sue Mosher [MVP]" wrote:

The form must be published to the Organizational Forms library with
the
"send form definition with item" box on the (Properties) page in the
designer unchecked.

"Delnang" wrote in message
...
I have code behind a command button:
Example:

Item.Body = Item.Body & vbCrLf & "new stuff"

and when I select the command button it works on my PC. When I send
the
email, and the recipient clicks the button, nothing happens.

How can I make it so the button work so that if one were to get the
form
from the Org. Library, the command buttons run the code?

Thanks,
Angie







Sue Mosher [MVP][_3_] September 30th 09 06:50 PM

Script only runs on my PC
 
Rearrange the order of the three terms in the expression that sets the new
value of Item.Body.

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


"Delnang" wrote in message
...
Again, Thank you!

One last question? Approx. 95% of our users have signatures. How do you
go
about getting that custom code to appear above one's signature. Right
now,
it is appearing below it.

Thanks,
Angie

"Sue Mosher [MVP]" wrote:

1) Item.Body = Item.Body & vbCrLf & Now()

2) http://support.microsoft.com/?id=840393



"Delnang" wrote in message
...
Thank you! What great knowledge.

1) What would the code look like? I am not very well versed. I get
confused as to where () and "" go.
& "concat(=now(),"new stuff")"
??? something like that?

2) Outlook 2003 SP3 for questions: Is there a way to surpress
automatic
signatures in an Outlook form?

Thank you,
Angie

"Sue Mosher [MVP]" wrote:

1) Yes, Now() is the correct function. Concatenate with to your
existing
expression used to set Item.Body.

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


"Delnang" wrote in message
...
Yes, that worked like a charm. I knew it would be easy.

Two addtional questions:
1. Is there a way to add an =now() type statement to this so that
one
would
know when the text was added to an email?

2. Is there a way to surpress automatic signatures in an Outlook
form?

Thanks,
Angie

"Sue Mosher [MVP]" wrote:

The form must be published to the Organizational Forms library with
the
"send form definition with item" box on the (Properties) page in
the
designer unchecked.

"Delnang" wrote in message
...
I have code behind a command button:
Example:

Item.Body = Item.Body & vbCrLf & "new stuff"

and when I select the command button it works on my PC. When I
send
the
email, and the recipient clicks the button, nothing happens.

How can I make it so the button work so that if one were to get
the
form
from the Org. Library, the command buttons run the code?

Thanks,
Angie









Delnang September 30th 09 08:10 PM

Script only runs on my PC
 
Sorry, I got lost by that. Here is my code:

Sub Employee_Signature_Click()
Item.Body = Item.Body & vbCrLf & Now()
Item.Body = Item.Body & vbCrLf & "I have read the document."
End Sub

What would be rearranged so the date/time and text appear above the signature?

Thanks,
Angie
"Sue Mosher [MVP]" wrote:

Rearrange the order of the three terms in the expression that sets the new
value of Item.Body.

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


"Delnang" wrote in message
...
Again, Thank you!

One last question? Approx. 95% of our users have signatures. How do you
go
about getting that custom code to appear above one's signature. Right
now,
it is appearing below it.

Thanks,
Angie

"Sue Mosher [MVP]" wrote:

1) Item.Body = Item.Body & vbCrLf & Now()

2) http://support.microsoft.com/?id=840393



"Delnang" wrote in message
...
Thank you! What great knowledge.

1) What would the code look like? I am not very well versed. I get
confused as to where () and "" go.
& "concat(=now(),"new stuff")"
??? something like that?

2) Outlook 2003 SP3 for questions: Is there a way to surpress
automatic
signatures in an Outlook form?

Thank you,
Angie

"Sue Mosher [MVP]" wrote:

1) Yes, Now() is the correct function. Concatenate with to your
existing
expression used to set Item.Body.

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


"Delnang" wrote in message
...
Yes, that worked like a charm. I knew it would be easy.

Two addtional questions:
1. Is there a way to add an =now() type statement to this so that
one
would
know when the text was added to an email?

2. Is there a way to surpress automatic signatures in an Outlook
form?

Thanks,
Angie

"Sue Mosher [MVP]" wrote:

The form must be published to the Organizational Forms library with
the
"send form definition with item" box on the (Properties) page in
the
designer unchecked.

"Delnang" wrote in message
...
I have code behind a command button:
Example:

Item.Body = Item.Body & vbCrLf & "new stuff"

and when I select the command button it works on my PC. When I
send
the
email, and the recipient clicks the button, nothing happens.

How can I make it so the button work so that if one were to get
the
form
from the Org. Library, the command buttons run the code?

Thanks,
Angie










Sue Mosher [MVP][_3_] September 30th 09 08:38 PM

Script only runs on my PC
 
This is so very, very basic that you need to learn it, so I'm not going to
give you the answer, only hints. You already seem to know that you can
combine content strings with the & operator. What happens if you change the
order of the terms separated by & in your code below?

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


"Delnang" wrote in message
...
Sorry, I got lost by that. Here is my code:

Sub Employee_Signature_Click()
Item.Body = Item.Body & vbCrLf & Now()
Item.Body = Item.Body & vbCrLf & "I have read the document."
End Sub

What would be rearranged so the date/time and text appear above the
signature?

Thanks,
Angie
"Sue Mosher [MVP]" wrote:

Rearrange the order of the three terms in the expression that sets the
new
value of Item.Body.

"Delnang" wrote in message
...
Again, Thank you!

One last question? Approx. 95% of our users have signatures. How do
you
go
about getting that custom code to appear above one's signature. Right
now,
it is appearing below it.

Thanks,
Angie

"Sue Mosher [MVP]" wrote:

1) Item.Body = Item.Body & vbCrLf & Now()

2) http://support.microsoft.com/?id=840393



"Delnang" wrote in message
...
Thank you! What great knowledge.

1) What would the code look like? I am not very well versed. I get
confused as to where () and "" go.
& "concat(=now(),"new stuff")"
??? something like that?

2) Outlook 2003 SP3 for questions: Is there a way to surpress
automatic
signatures in an Outlook form?

Thank you,
Angie

"Sue Mosher [MVP]" wrote:

1) Yes, Now() is the correct function. Concatenate with to your
existing
expression used to set Item.Body.

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


"Delnang" wrote in message
...
Yes, that worked like a charm. I knew it would be easy.

Two addtional questions:
1. Is there a way to add an =now() type statement to this so
that
one
would
know when the text was added to an email?

2. Is there a way to surpress automatic signatures in an Outlook
form?

Thanks,
Angie

"Sue Mosher [MVP]" wrote:

The form must be published to the Organizational Forms library
with
the
"send form definition with item" box on the (Properties) page in
the
designer unchecked.

"Delnang" wrote in message
...
I have code behind a command button:
Example:

Item.Body = Item.Body & vbCrLf & "new stuff"

and when I select the command button it works on my PC. When
I
send
the
email, and the recipient clicks the button, nothing happens.

How can I make it so the button work so that if one were to
get
the
form
from the Org. Library, the command buttons run the code?

Thanks,
Angie













All times are GMT +1. The time now is 09:51 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com