Collating information from a custom form

[Barry Sion]

Hi all,

I have just created a custom form for work and I was wondering if it is
possible to write a script or some such that will allow me to collate all the
information (in field order) in something like Access or Excel?

Basically the form comprises of order and delivery details and at the end of
the day I currently have to trawl through all the forms used in a day
(somewhere between 20-50 forms with a load of information on each) and enter
all the data into a corresponding database. I was hoping there was a way to
grab the information automatically so I can bypass this time consuming task.

Thanks in advance.

 

[Sue Mosher [MVP-Outlook]]

Yes, it's possible to write code to do that. See
http://www.outlookcode.com/article.aspx?ID=23 for samples.