Excel.xlt Published as Form in Public Folders

[Shauna Koppang]

I have created and Excel XP template and I know I read
somewhere a while ago that you can publish Excel templates
or even Word templates to a folder within Outlook.

What I am trying to do is publish a Purchase Order
template that when a user goes into the Purchase Order
Folder in Public Folders, and creates a new item it
creates a new item based on this template and it would
then be stored in that folder and notifications to our
purchasing agent that an item is there is issued and so
on. Status and other notifications could then be sent to
the user et al.

Can anyone please help me with this or give in a direction
to look in, I would be very appreciative I have a
published a couple of forms from within Outlook before,
but am a beginner.

Thanks so much!

Shauna

 

[Sue Mosher [MVP]]

In Outlook 2000, choose File | New | Office Document. Create your spreadsheet there, then use the Tools | Forms | Publish Form command to publish the item as a form to the public folder.
--
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

 

[Phil Montgomery]

I beg to differ. Office XP does have this feature. If you
are creating a form you have an icon on the tool bar that
looks like a hammer. Click that. This will open the VBA
objest toolbar. If you right click on that tool bar you
will be able to add other objects. Scroll down until you
come to Microsoft Excel 10.0, put a check in the box and
another icon will be placed on your VBA objects toolbar.
All you have to do then is drag the excel spreadsheet
object onto your form.

-----Original Message-----
Office XP really doesn't offer this type of feature. If

you have an earlier version of Office, though, you can
create an Office document form with an Excel spreadsheet
built into the form.

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


"Shauna Koppang" <[email protected]> wrote

in message news:[email protected]...

 

[Sue Mosher [MVP]]

If only it were that easy. You also have to provide code that stores the data from the spreadsheet between uses of the item. (See http://www.slipstick.com/dev/spreadsheetcontrol.htm.) This is quite a bit beyond the simple Excel template concept that the original poster seemed to be thinking of and that the Outlook 2000 Office document form provided.

FYI, if anyone needs Office 2000-style Office document form templates for Outlook, I've posted blank ones at http://www.slipstick.com/files/office document forms.zip. Open the PST file from the zip download in Outlook; usage details are in the Read Me First item.
--
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