How To Export Customer Email Addresses to CSV

[andswan]

It seems like this should be a simple feature, but I can't find it anywhere. Can someone help?

Thanks!

I've labeled this a How To so that someone else can find it when it's answered.

[s_ismail]

You can export email addresses by going on Admin-->Marketing-->Email Lists-->ManageList Page(Edit List).

[andswan]

Yeah, that's what I thought would be the logical move. However, I'm trying to export a list of anyone that has ever made a purchase on my site. Right now I can only see one list which someone before me made called eNewsletter, but it only has 235 emails or 17 pages of emails. Whereas, I can look under sales by customer and there are easily 35 pages of emails. So I'm just confused.

[andswan]

Nevermind, You basically have to go to Admin-->Marketing-->Email Lists-->ManageList Page(Edit List), then make a new list by putting something for name like "all emails" and then click save. In the Manage List page, click "Manage Users" and then click quick search "All" Then you can browse and add all the emails, from there you can export them to CSV. It's still pretty tedious because you have to go through each page like it's 1998.

[andswan]

Okay, is there no way to do this faster????

[AbleMods]

If you have direct access to your SQL database, you could pull out the BillToEmail from ac_Orders to build your master list.

Another alternative is a page I wrote that lets you mass-mail customers who bought a specific product within a specified timeframe. You can find the code in the helpful posts forum:viewtopic.php?f=47&t=15301

That page could probably be easily modified to pull everything if no product SKU is specified - that would accomplish what you need I think.

[andswan]

Thanks Joe, what code would I need to put in to do that? I downloaded your mass email program, and I'm looking at the code right now, but I'm learning how to do this on the spot so any help would be appreciated! You designed our site after all.

[AbleMods]

It's a simple modification, just one line.

Find this line in the code:

Code: Select all

sql.Append("where i.sku = @sku");

and replace it with this line:

Code: Select all

sql.Append("where i.sku LIKE @sku");

Then save the change.

Now if you want to use that page to email anyone who has bought ANYTHING from your store within a specific time period, just enter a percent-sign (%) as the SKU instead of a specific SKU value.

The percent-sign is like a wildcard (*) symbol in SQL query statements that use a LIKE operator.

You can still use the page for a specific SKU by entering the exact SKU value as before. All we've done here is add support for a wildcard value.

[andswan]

Ahhh, thank you so much!