Printing customers address's from database

5 Nov 2008, 11:05 PM

New Zenner

Join Date:: Jun 2006
Posts:: 35
Plugin Contributions:: 0

Printing customers address's from database

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

6 Nov 2008, 1:27 AM

mprough

Totally Zenned

Join Date:: Nov 2007
Location:: Woodbine, Georgia, United States
Posts:: 4,290
Plugin Contributions:: 39

Re: Printing customers address's from database

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

~Melanie

6 Nov 2008, 9:24 AM

fairestcape

Totally Zenned

Join Date:: Mar 2008
Location:: Cape Town & London (depends on the season)
Posts:: 2,957
Plugin Contributions:: 0

Re: Printing customers address's from database

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.)