Excel sheet in Outlook form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bas Harnas - 08 Jan 2005 21:41 GMT

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?

Reply to this Message

Sue Mosher [MVP-Outlook] - 09 Jan 2005 04:31 GMT

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.

Signature

Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

> Hi,
> I was trying to add-in a Microsoft Office Spreadsheet Custom Control
[quoted text clipped - 17 lines]
> Can anybody tell me how to attach this Excel Control to already written
> messages?

Reply to this Message