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.

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.
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"CC Santa Monica" wrote in message ...
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.

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


"CC Santa Monica" wrote:

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.

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.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"CC Santa Monica" wrote in message ...
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


"CC Santa Monica" wrote:

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.