Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Outlook / Programming Forms / June 2007

Tip: Looking for answers? Try searching our database.

Export Excel Table to Form Message

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
CC Santa Monica - 25 Jun 2007 23:50 GMT
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] - 26 Jun 2007 19:28 GMT
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.
Signature

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

> 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.
CC Santa Monica - 26 Jun 2007 20:26 GMT
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

> 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] - 26 Jun 2007 20:37 GMT
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.

Signature

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

> Thanks,
>
[quoted text clipped - 19 lines]
>>
>> Thanks.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.