Hello,
My company have been raising our sales orders manually in word over the last
2 years and now the time has come to transfer it all to a sage system. Our
sage consultants advise that they can export all data to Sage as long as it
is in a CSV format - which means using excel.

Our sales orders have a header table section giving delivery address etc
followed by a number of lines in another table detailing what the customer
has ordered and what price they paid etc.

We have over 2000 of these word documents that need putting into a csv
format. Does anyone have any suggestions about any quicker, easier methods
of doing so than manually transfering all the data from word into excel, as
that would take hours!

I did wonder about the use of macros to get the address header table into
excel but I wondered how you used macros and got them to automatically start
on the next line after completing the first line.

If theres anyone out there that can help do let me know!

Easy enought to do with a macro. Given the quantity to be done, and the
(presumed) value of the data, pay someone to do it. It's a couple of days
work all up.




"Klann Tools" Klann wrote in message
...
Hello,
My company have been raising our sales orders manually in word over the
last
2 years and now the time has come to transfer it all to a sage system.
Our
sage consultants advise that they can export all data to Sage as long as
it
is in a CSV format - which means using excel.

Our sales orders have a header table section giving delivery address etc
followed by a number of lines in another table detailing what the customer
has ordered and what price they paid etc.

We have over 2000 of these word documents that need putting into a csv
format. Does anyone have any suggestions about any quicker, easier
methods
of doing so than manually transfering all the data from word into excel,
as
that would take hours!

I did wonder about the use of macros to get the address header table into
excel but I wondered how you used macros and got them to automatically
start
on the next line after completing the first line.

If theres anyone out there that can help do let me know!