If you use Google Apps for your email service, how do you export or list all of your email accounts and email aliases without clicking through each account one by one? Here’s how:
- Login as the an administrator for the Google Apps account
- Navigate to Apps
- Click on Gmail
- Click on Advanced Settings »
- Select Email addresses
That’s it. You should now be looking at a chart showing Email addresses, Type (account vs. alias) and Recipient. If you highlight the chart and copy it, this will paste very nicely into Excel.
As a shortcut, this URL might work for you, if you edit it to include your own domain name:
https://admin.google.com/YOURDOMAIN.COM/AdminHome?fral=1#ServiceSettings/service=email&subtab=addresses