Printing customers address's from database

[cushietushies]

Hi all!!!

Another question from me.. Thanks so much for your help in the past :)

We need to print some Address's for Christmas Cards from our Database but 600 hand written cards sounds a little daunting.

Is there any way to print address labels straight from the database?

TIA!
Shell

[mprough]

Export a Backup your DB and grab the fields.. save them as a csv

~Melanie

[fairestcape]

Melanie's suggestiuon is a good one. I would use phpMyAdmin to export just the customer name and address fields as a CSV file.

This data is nicely contained in the table titled: address_book .

(This table does not contain the country or the "zone", however - just the ID's for these data sets which are "married up" with the countries and zones tables.)