Thanks, Michael. Yes - I tried that option, and as you say, the formatting is not great!
What I want to do with the information is as follows:
It is for the purpose of sending samples to US tradeshows and creating the required customs documentation. First, an order is created in OE. We have created ProForma Spec file for printing that shows the weight, country of origin, tariff item, etc. - all the stuff that is needed to ship to the US.
However, unless it is actually INVOICED, values and weights are not totalled. So, if I could export all the details to Excel,
I can create the necessary docs without actually invoicing.
I will try the gridview report as suggested by Support. Probably tomorrow!
Thanks for all your help so far!