I would either use phpMyAdmin, or write a custom script to query the database and get the email addresses. Maybe something like this. I only have 1.5 installed anywhere, so if the table or field names are different, they will have to be modified.
PHP Code:
<?php
include("includes/configure.php");
mysql_connect(DB_SERVER,DB_SERVER_USERNAME,DB_SERVER_PASSWORD);
mysql_select_db(DB_DATABASE);
$q = "SELECT * FROM " . DB_PREFIX . "customers ORDER BY customers_firstname;";
if($r = mysql_query($q)){
$output = "
<table>
<tr>
<th>Customer Name</th>
<th>Customer Email Address</th>
</tr>";
while($row = mysql_fetch_assoc($r)){
$output .= "
<tr>
<td>" . $row['customers_firstname'] . " " . $row['customers_lastname'] . "</td>
<td>" . $row['customers_email_address'] . "</td>
</tr>";
}
$output .= "
</table>";
echo $output;
} else {
echo "Query Failed: " . mysql_error();
}
?>
Bookmarks