Excel sheet in Outlook form

[Guest]

Hi,
I was trying to add-in a Microsoft Office Spreadsheet Custom Control
and so being able to display an Excel sheet in an Outlook form. This
works fine.
However, when I post the contents (with IPM.Note or IPM.Post) it will
not display the contents. So when I open the form, I see the Excel sheet and
can do whatever I want and I can post it. But reading after posting the
message is more
or less empty.

The message after opening is :
to help prevent malicious code from running, one or more objects in
this form were not loaded.

Any help would be greatly appreciated

(Form is published in Personal Forms library, Office version is 2003)


Can anybody tell me how to attach this Excel Control to already written
messages?

 

[Sue Mosher [MVP-Outlook]]

You have to store the data from the spreadsheet in the Outlook item and then
read it back into the control when the item opens again. See
http://www.outlookcode.com/d/spreadsheetcontrol.htm for sample code.

Also, from the warning message symptom, it seems you have not published the
form. You will need to publish it if you want the spreadsheet control to
work on it. See http://www.outlookcode.com/d/ol2003problems.htm, under
ActiveX Controls.