![]() |
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Search this Thread | Display Modes |
#1
|
|||
|
|||
![]()
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 |
Ads |
#2
|
|||
|
|||
![]()
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 |
#3
|
|||
|
|||
![]()
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 |
#4
|
|||
|
|||
![]()
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 |
#5
|
|||
|
|||
![]()
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 |
#6
|
|||
|
|||
![]()
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 |
#7
|
|||
|
|||
![]()
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 |
#8
|
|||
|
|||
![]()
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 |
#9
|
|||
|
|||
![]()
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 |
#10
|
|||
|
|||
![]()
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 |
|
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Script help - retain forwarded email body & location of script | Dawn[_2_] | Outlook and VBA | 5 | July 16th 09 05:35 PM |
Outlk 2k3 Script: Saving Excel File programticaly from OUTLOOK SCRIPT | news.microsoft.com | Outlook and VBA | 3 | November 22nd 06 03:33 PM |
Rule that runs an script that should call an SQL Server sentence | Carlos | Outlook and VBA | 2 | August 29th 06 07:25 AM |
Running a script when Outlook runs for the first time | [email protected] | Outlook - Installation | 1 | August 4th 06 12:45 PM |
Outlook 2003 "find" contacts doesn't work, just runs and runs | Tom Stanley | Outlook - Using Contacts | 1 | July 5th 06 03:56 AM |