Cant Export All Orders??

[jharrison]

Hi

I want to export all my orders to file, in order to gather customer email addresses.

Problem is, when I select all the orders, and click re-export orders, I get a box saying to many records selected. Seems I can select about 100 at a time? Is this something that I have switched on, or is it a bug?

I dont really fancy creating a file for evey 100 orders!

Any help appreciated


James

[pinbrook]

If you have a copy of Access I would create a query to extract the info you want

[jharrison]

So is it a bug of the program?

[cdicken]

It's not a bug - but it is a limitation that was imposed for technical reasons.

I would open up the ActinicCatalog.mdb database in Access and then pull the email addresses from the 'Person' table.

[DBurrows]

When i have looked at this previously it lists 2 entries for each customer (Inoive and Delivery Email addresses), whats the best way to filter out the unique ones?

[Jan]

You get two entries in the export files as well, one is for the delivery address and one is for the invoice address.

You can either use the DISTINCT clause in the SQL (or if this refuses to work try GROUP BY with TOP 1) or if that makes no sense then load them up into a free email marketing tool such as group mail (http://www.mole-end.biz/acatalog/Free_Solutions.html) and it will remove duplicates as it loads them.

Regards,