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.

Yes, it's possible to write code to do that. See
http://www.outlookcode.com/article.aspx?ID=23 for samples.
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Barry Sion" wrote:

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