![]() |
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
|
|||
|
|||
![]()
Hi. This is my first posting here so I thought I'd start off with a wave.
{wave} ![]() Okay, I am building a form as a round robin. Basically, when we have an issue relating to a student, a relevant senior member of staff will send the form to all relevant staff. The original form will have the student's name, the date of return and the reason for the concern. The receiver is to then fill out further information relevant to their area of work and then return the form to the original source. To simplify everything I have created a button, entitled Return Form and named btnReturn. I have then entered the code: sub btnReturn_click() item.send end sub I cannot see how this will send the form back to the correct person but I have even put a simple msgbox statement in the code and nothing happens. Do I place this code in the Script window or in the VBA editor for the current session? Equally, I have created the compose view and the read view. So, when it is returned, is it the read view that is viewable to the original sender? But primarily, how do I get this button to work? Sorry for the barrage of questions but whilst I await a new book I could do with some serious assistance here. |
#2
|
|||
|
|||
![]()
The first issue we need to tackle is whether it's possible for you to
implement any custom message forms with VBScript code at all. Do you have permission to publish forms to the Organizational Forms library on your company's Exchange server? If not, then Outlook forms are not likely to be a practical solution. You would need to give each person a copy of the form along with instructions on how to publish it to their own Personal Forms library. And you'd have to do that again every time you made a change to the form. -- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 "Gary Newport" wrote: Hi. This is my first posting here so I thought I'd start off with a wave. {wave} ![]() Okay, I am building a form as a round robin. Basically, when we have an issue relating to a student, a relevant senior member of staff will send the form to all relevant staff. The original form will have the student's name, the date of return and the reason for the concern. The receiver is to then fill out further information relevant to their area of work and then return the form to the original source. To simplify everything I have created a button, entitled Return Form and named btnReturn. I have then entered the code: sub btnReturn_click() item.send end sub I cannot see how this will send the form back to the correct person but I have even put a simple msgbox statement in the code and nothing happens. Do I place this code in the Script window or in the VBA editor for the current session? Equally, I have created the compose view and the read view. So, when it is returned, is it the read view that is viewable to the original sender? But primarily, how do I get this button to work? Sorry for the barrage of questions but whilst I await a new book I could do with some serious assistance here. |
#3
|
|||
|
|||
![]()
I have full permission to the organisational library.
As further information, We are using Exchange 2003 with Outlook 2003 as the client application; though the network manager is intending to move to Outlook 2007 soon. I will, however, continue to design forms for Outlook 2003 for the foreseeable time, until the roll-out can be guaranteed as 100% coverage and reliable. ![]() "Sue Mosher [MVP-Outlook]" wrote: The first issue we need to tackle is whether it's possible for you to implement any custom message forms with VBScript code at all. Do you have permission to publish forms to the Organizational Forms library on your company's Exchange server? If not, then Outlook forms are not likely to be a practical solution. You would need to give each person a copy of the form along with instructions on how to publish it to their own Personal Forms library. And you'd have to do that again every time you made a change to the form. -- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 "Gary Newport" wrote: Hi. This is my first posting here so I thought I'd start off with a wave. {wave} ![]() Okay, I am building a form as a round robin. Basically, when we have an issue relating to a student, a relevant senior member of staff will send the form to all relevant staff. The original form will have the student's name, the date of return and the reason for the concern. The receiver is to then fill out further information relevant to their area of work and then return the form to the original source. To simplify everything I have created a button, entitled Return Form and named btnReturn. I have then entered the code: sub btnReturn_click() item.send end sub I cannot see how this will send the form back to the correct person but I have even put a simple msgbox statement in the code and nothing happens. Do I place this code in the Script window or in the VBA editor for the current session? Equally, I have created the compose view and the read view. So, when it is returned, is it the read view that is viewable to the original sender? But primarily, how do I get this button to work? Sorry for the barrage of questions but whilst I await a new book I could do with some serious assistance here. |
#4
|
|||
|
|||
![]()
In that case, to allow code to run for both senders and recipients inside
your organization, make sure you publish the form to the Organizational Forms library with the "send form definition with item" box on the (Properties) page always unchecked. As for the specific code, one solution would be to forward the item back to the original sender. You can do that with this code: Sub btnReturn_click() Set fwd = Item.Forward fwd.To = "[EX:" & Item.SenderEmailAddress & "]" If fwd.Recipients.ResolveAll Then fwd.Send Else fwd.Display End If End Sub If you use that approach, on the (Actions) page of the form, make sure you set the Forward action to use the published form. -- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 "Gary Newport" wrote: I have full permission to the organisational library. As further information, We are using Exchange 2003 with Outlook 2003 as the client application; though the network manager is intending to move to Outlook 2007 soon. I will, however, continue to design forms for Outlook 2003 for the foreseeable time, until the roll-out can be guaranteed as 100% coverage and reliable. ![]() Hi. This is my first posting here so I thought I'd start off with a wave. {wave} ![]() Okay, I am building a form as a round robin. Basically, when we have an issue relating to a student, a relevant senior member of staff will send the form to all relevant staff. The original form will have the student's name, the date of return and the reason for the concern. The receiver is to then fill out further information relevant to their area of work and then return the form to the original source. To simplify everything I have created a button, entitled Return Form and named btnReturn. I have then entered the code: sub btnReturn_click() item.send end sub I cannot see how this will send the form back to the correct person but I have even put a simple msgbox statement in the code and nothing happens. Do I place this code in the Script window or in the VBA editor for the current session? Equally, I have created the compose view and the read view. So, when it is returned, is it the read view that is viewable to the original sender? But primarily, how do I get this button to work? Sorry for the barrage of questions but whilst I await a new book I could do with some serious assistance here. |
#5
|
|||
|
|||
![]()
Thanks for this.
One more stupid question; does thi code into "View Code" or directly into the currentsession of the VBA Editor? "Sue Mosher [MVP-Outlook]" wrote: In that case, to allow code to run for both senders and recipients inside your organization, make sure you publish the form to the Organizational Forms library with the "send form definition with item" box on the (Properties) page always unchecked. As for the specific code, one solution would be to forward the item back to the original sender. You can do that with this code: Sub btnReturn_click() Set fwd = Item.Forward fwd.To = "[EX:" & Item.SenderEmailAddress & "]" If fwd.Recipients.ResolveAll Then fwd.Send Else fwd.Display End If End Sub If you use that approach, on the (Actions) page of the form, make sure you set the Forward action to use the published form. -- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 "Gary Newport" wrote: I have full permission to the organisational library. As further information, We are using Exchange 2003 with Outlook 2003 as the client application; though the network manager is intending to move to Outlook 2007 soon. I will, however, continue to design forms for Outlook 2003 for the foreseeable time, until the roll-out can be guaranteed as 100% coverage and reliable. ![]() Hi. This is my first posting here so I thought I'd start off with a wave. {wave} ![]() Okay, I am building a form as a round robin. Basically, when we have an issue relating to a student, a relevant senior member of staff will send the form to all relevant staff. The original form will have the student's name, the date of return and the reason for the concern. The receiver is to then fill out further information relevant to their area of work and then return the form to the original source. To simplify everything I have created a button, entitled Return Form and named btnReturn. I have then entered the code: sub btnReturn_click() item.send end sub I cannot see how this will send the form back to the correct person but I have even put a simple msgbox statement in the code and nothing happens. Do I place this code in the Script window or in the VBA editor for the current session? Equally, I have created the compose view and the read view. So, when it is returned, is it the read view that is viewable to the original sender? But primarily, how do I get this button to work? Sorry for the barrage of questions but whilst I await a new book I could do with some serious assistance here. |
#6
|
|||
|
|||
![]()
Code for a custom form goes into the form's code editor (View Code). VBA code
is an entirely separate code environment. -- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 "Gary Newport" wrote: Thanks for this. One more stupid question; does thi code into "View Code" or directly into the currentsession of the VBA Editor? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Task Form Manipulation Issue | jcurcurato | Outlook - Using Forms | 1 | December 1st 06 03:00 AM |
Custom Form resize issue | VB | Outlook - Using Forms | 0 | May 24th 06 08:34 PM |
Outlook and Form Issue | Jade | Outlook - Using Forms | 3 | May 1st 06 02:19 AM |
issue with opening form | sele | Outlook - Using Forms | 1 | March 24th 06 01:29 PM |
Having an issue with Check Full Name form | Bo | Outlook - Using Contacts | 1 | February 24th 06 01:20 PM |