Exporting csv file from the database

[Elkos]

Hey guys, can somebody help me with a little issue I am having.

What would be the easiest way for me to extract the csv file from my database. This file should contain the email address of my clients as well as the order number.

I would appreciate if somebody has that knowledge and could share it.

Gene

[Duncan Rounding]

You will need some basic knowledge of databases to do this. In the database the Order table contains the order number, the Order Detail table contains the order lines from each order and the Person table contains the delivery and invoice address details of each customer.

If you're happy just to get the customer email addresses without the order number then you can simply link to the table from Excel by Importing External data in the Tools menu.

[Chunkford]

Doesn't the Mailing Lists option under Marketing do the job?

[Duncan Rounding]

True, this will give all customers and their latest order number but not all the order numbers from each customer - depends on what data you want.