exporting all customer addresses for bulk mailing?

[Guest]

Searched the site up and down, can only find a contrib that will export them one at a time via the admin.

 

I need to find one that will function somewhat like easypopulate does for the merchandise. This will serve 2 purposes for me, I would like to send out a discount sales flyer for the holiday season and include my internet customers in it (even the ones who have not purchased yet). Also, a customer may sign up on the site, but might never complete a sale, then call in a month later to purchase over the phone, we input these sales directly into quickbooks, it would be cool if their information was already in there.

 

Any help would be appreciated! I need to know how many flyers Kinkos should print up and it will only be half if I cant figure this out.

[Guest]

use mysql odbc from mysql.com and export the info into excel

[Guest]

Thanks mibble I will check that out!

[Guest]

I downloaded the file and installed it, went into excel and tried to pull it up but having a hard time with the server name. I have no idea how it should be formatted.

 

Can you use a local file with this obdc? My server is a shared server with a hosting company.

[Guest]

ask your host if odbc will work for you to extract info from the database. if not, then load mysql on your local computer, download the sql database and then extract it on the local copy. you dont need to have apache and php running, although is nice, that way you can make code changes and test prior to sending up to your site.

[Guest]

Thanks! I believe I have a work around, my isp provides an export utility in mySQL that will give you a CSV file for only tables I select. I downloaded that, opened it and pruned what I needed. I converted the country table and am working on the State now.

 

To get this mailing out, would you import the address and customer list into quickbooks, which could be considerably more work since I have to figure out how, but less when it comes time to printing, also I would have the customers then in quickbooks as I originally planned

 

or

 

just print this half of the mailing labels from excel somehow?

[spannerman2]

Get "phpMyAdmin" and install that on your webspace, connect it to your database server and use that to manage your mySQL database.

 

I upload and download Excel compliant CSV's for all the tables on a regular basis!

 

You also want to password protect the phpMyAdmin folder for security, so that no one else can get to your DB.

 

There is a mod for printing labels, which I haven't managed to get working yet, which is why I'm here! (Seeing if there's a response to my support request in the Forum!)