problem with spreadsheet control on form

[Magnus Pesch]

Hi NG!

A question from Germany:
I put a spreadsheet control on a built-in Outlook(2K)-Form, where I want to
write data programmatically or the data is changed by eMail-Recipient...
I do not need the Item.Body Property, so I can save Spreadsheet.HTMLData in
Item.Body - when the form(eMail) is sent, saved or closed then I save the
data like this way.
In the event Item_Open, I want to get the data back in the spreadsheet
control, but there is a problem...: i.e. when the form(eMail) was sent or
received and the user is opening it, there is no data in the control - I
tested it and I recognized, that the event Item_Open is not fired!??? What
am I doing wrong? I don't understand this...

Tanks.
Magnus Pesch

 

[Magnus Pesch]

Thanks for your extensive answer - I will see if I can manage it...

Bye and Greetings.

If the form 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.outlookcode.com/d/secforms.htm 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
Outlook and Exchange solutions at http://www.slipstick.com
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

Hi NG!

A question from Germany:
I put a spreadsheet control on a built-in Outlook(2K)-Form, where I want to
write data programmatically or the data is changed by eMail-Recipient...
I do not need the Item.Body Property, so I can save Spreadsheet.HTMLData in
Item.Body - when the form(eMail) is sent, saved or closed then I save the
data like this way.
In the event Item_Open, I want to get the data back in the spreadsheet
control, but there is a problem...: i.e. when the form(eMail) was sent or
received and the user is opening it, there is no data in the control - I
tested it and I recognized, that the event Item_Open is not fired!??? What
am I doing wrong? I don't understand this...