Cannot open a form if input spreadsheet

[thtsps]

Hi,

Pls help on a topic as above. I've created a form with spreadsheet and got
error after sent to other person that "To help prevent malicious code from
running, one or more objects in this form were not loaded.for more
information, contact your administrator" If you have any suggestion pls let
me know, please. Thank you.

 

[Sue Mosher [MVP-Outlook]]

You'll need to publish the form. The warning you cited is normal for unpublished forms.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[thtsps]

Hi sue,

Thank your for your help. I've posted in publishe already, but still
getting this error. Pls help. Thank you

 

[Hollis D. Paul]

Thank your for your help. I've posted in publishe already, but still
getting this error. Pls help. Thank you

Publish, as Sue is using the term, means that when you have the custom
form in design mode, you click Tools -> Forms -> Publish Form or Publish
Form As, and then follow the wizard to publish the form to the desired
Outlook or Exchange folder. (It is not something you do with an
application you call Publisher.)

I always recommend that you use Publish Form As, because it forces you
to create a new name for the form, and you avoid all possible forms
cache problems. I also recommend that you include the version in the
name--MyForm_Ver00n, where n progresses from 1 to however many versions
you need to get the form to do what you want it to do.

Hollis D. Paul [MVP - Outlook]
Mukilteo, WA USA

 

[thtsps]

Thank you so much for your help. But, some problem occure when i sent to
myself. Why I got a blank form and nothing data in the speadsheet. Pls help
me for the code. Thank you.
PS.I posted this form in my personal form library for a test first. This is
a cause of this problem ?

Thank your for your help. I've posted in publishe already, but still
getting this error. Pls help. Thank you

Publish, as Sue is using the term, means that when you have the custom
form in design mode, you click Tools -> Forms -> Publish Form or Publish
Form As, and then follow the wizard to publish the form to the desired
Outlook or Exchange folder. (It is not something you do with an
application you call Publisher.)

I always recommend that you use Publish Form As, because it forces you
to create a new name for the form, and you avoid all possible forms
cache problems. I also recommend that you include the version in the
name--MyForm_Ver00n, where n progresses from 1 to however many versions
you need to get the form to do what you want it to do.

Hollis D. Paul [MVP - Outlook]
Mukilteo, WA USA

 

[Hollis D. Paul]

PS.I posted this form in my personal form library for a test first. This is
a cause of this problem ?

No. It is not any problem if you posted in your personal form library. What
is likely the problem is that you did not send your message using the TNEF
wrapper. You force the use of the TNEF wrapper by opening the contact item
for the target email address, selecting the email address in the contact item,
right-clicking and choosing properties. At the bottom of the properties panel
is a check box labeled "Always send to this address using rtf format." Or
something similar. This is for Outlook 2002 and older. In Outlook 2003, the
is an email format listbox. Select the rtf format entry.

It could also be that you created a split page form, with both a read form and
a compose form; and only put your spread sheet on the compose form. You
should always start the design process in the un-split state, and include all
the common elements. Then, split the form and create the unique parts.

Hollis D. Paul [MVP - Outlook]
Mukilteo, WA USA