Exporting Customer emails

[mendocinomaples]

Is there a way to take the names and emails of the customers in the News address book or Specials address book and export it to a cvs file or tab delimited text file?

[Jamie]

You would have to use phpMyAdmin to export to a CSV file.

1. Find the record_number of the group you want the addresses for

2. Open phpMyAdmin

3. Click the SQL tab

4. Past this query into the query box:

SELECT
     CONCAT(c.`First_Name`,' ',c.`Last_Name`) AS `Name`
    ,c.`Email_Address`
FROM
    `Customers` c
LEFT JOIN
    `REL_Customers__Groups` cg
ON
    cg.`Customers_rn` = c.`record_number`
WHERE
    cg.`Groups_rn` = 15
GROUP BY
    c.`record_number`

5. Change the 15 at the end to match the group's record_number

6. Click Go

7. You should now have the data you want

8. Scroll down and click the Export link
example1.png

9. Choose the file format and click Go

[ITPDiesel]

would it be possible to use a simple database query to generate a list of email addresses that belong to a certain group and display them on the screen...allowing for a copy/paste into a text file?

[Jamie]

Change the 3 to the group number you want members of:

SELECT
    DISTINCT c.`Email_Address`
FROM
    `REL_Customers__Groups` cg
LEFT JOIN
    `Customers` c
ON
    cg.`Customers_rn` = c.`record_number`
WHERE
    cg.`Groups_rn` = 3
    AND c.`Email_Address` IS NOT NULL
ORDER BY
    c.`Email_Address`