Export Excel Table to Form Message

[CC Santa Monica]

Does anyone know how to export an excel file/or access table to a form
directly? I have a table I would like to export weekly to a form so users can
update data fields.

Thanks.

 

[Sue Mosher [MVP-Outlook]]

Could you provide more details on what you're trying to do? It's not quite clear how you envision an Outlook custom form being used to update another source. Your version of Outlook and whether you can publish to the Exchange server's Organizational Forms library may also be relevant.

 

[CC Santa Monica]

Thanks,

I have outlook 2003 and I can't publish to the exchange server's forms
library.

Basically I have a table of data that changes on a weekly basis. Users need
to enter data in a number of columns and forward it on for review. We used to
use webposted excel files, but we want to use forms.

I would like to have the whole excel table appear in a form that users can
complete and then update a database with the info automatically when the
email is received back.

So the idea would be to export the file each week to a form, if possible, to
allow the user to input data.

Thanks

 

[Sue Mosher [MVP-Outlook]]

You can send an entire Excel table as the body of a message by using the File | Send To | Mail Recipient command. But using the Mail Recipient (For Review) command might give you what you need -- return copies that you can consolidate back into the original document. An Outlook form isn't going to give you that, especially since you'd have the deployment challenge of publishing it to every person's Personal Forms library.