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.

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.

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.

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.

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.

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?

Thanks for this. I will give it all a try tomorrow. The fun of learning, eh?

"Sue Mosher [MVP-Outlook]" wrote:

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?

Hi Sue again!

Okay, I have tried several times to put the code in but every time I close
the form the code disappears; lost into the ether! (

Do you know why? Am I missing a permissions thing (which I can get changed)
or am I doing something wrong?

I am using Outlook 2007, using View Code and pasting the code in, clicking
on Publish and then save. I am now saving to the organisational library area
(I am the only one working ion there and the employees know not to use the
form yet).

Help please! )

"Gary Newport" wrote:

Thanks for this. I will give it all a try tomorrow. The fun of learning, eh?

"Sue Mosher [MVP-Outlook]" wrote:

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?

I don't quite follow what you mean by "clicking on Publish and then save."
Publishing a form and saving an item are two entirely different things. After
you publish the form, to use that form, you can launch a new item with it
using the Tools | Forms | Choose Form command. If you want to design it again
(and see the code), use Tools | Forms | Design a 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 Sue again!

Okay, I have tried several times to put the code in but every time I close
the form the code disappears; lost into the ether! (

Do you know why? Am I missing a permissions thing (which I can get changed)
or am I doing something wrong?

I am using Outlook 2007, using View Code and pasting the code in, clicking
on Publish and then save. I am now saving to the organisational library area
(I am the only one working ion there and the employees know not to use the
form yet).

Help please! )

"Gary Newport" wrote:

Thanks for this. I will give it all a try tomorrow. The fun of learning, eh?

"Sue Mosher [MVP-Outlook]" wrote:

Code for a custom form goes into the form's code editor (View Code). VBA code
is an entirely separate code environment.


"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?

Sorry, keep creating confusion.

I save the form when I feel it is at a stage where I want to see it
function. I then publish it. As a matter of protection I then go to save it
again (in case the publishing has an impact on the form) and then close the
form.

I then open the form in the ToolsFormsChoose Form... or the
FileNewChoose Form.. route.

What I am finding is that, if I click on View Code and then paste your code
into the window, close the window, save and publish then I find that when I
run the form the button does nothing. When I return to design the form there
is nothing in the View Code window at all.

Slightly separately, is the View Code window generalistic (therefore all
code for the form will appear in there) or is it object-based (should I be
clicked on the button to apply the code for the button)?

Hope I have not added confusion.

"Sue Mosher [MVP-Outlook]" wrote:

I don't quite follow what you mean by "clicking on Publish and then save."
Publishing a form and saving an item are two entirely different things. After
you publish the form, to use that form, you can launch a new item with it
using the Tools | Forms | Choose Form command. If you want to design it again
(and see the code), use Tools | Forms | Design a 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 Sue again!

Okay, I have tried several times to put the code in but every time I close
the form the code disappears; lost into the ether! (

Do you know why? Am I missing a permissions thing (which I can get changed)
or am I doing something wrong?

I am using Outlook 2007, using View Code and pasting the code in, clicking
on Publish and then save. I am now saving to the organisational library area
(I am the only one working ion there and the employees know not to use the
form yet).

Help please! )

"Gary Newport" wrote:

Thanks for this. I will give it all a try tomorrow. The fun of learning, eh?

"Sue Mosher [MVP-Outlook]" wrote:

Code for a custom form goes into the form's code editor (View Code). VBA code
is an entirely separate code environment.


"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?