Google's John Mueller shared an insightful how-to post on Google+ on how to discover and then potentially remove email addresses that you accidentally let Google index on your web site.
Sometimes, through code issues, Google can discover email addresses you have in your database. It is not that uncommon for this to happen novice webmasters. When it does, it can be an embarrassing thing.
John Mueller showed on Google+ how to remove it.
First he said that if there is a common pattern, URL path, that shows the email addresses, then you can use a site command to see how bad it is:
Then, you can go to the Remove URLs feature and remove the path:
John explained:
For example, you can submit "email.php" to have all URLs that start with / use that script temporarily removed.(Why "temporary?" These removals only stay in place for a limited time; you need to take appropriate action to prevent URLs like that from being indexed in the first place. You might allow crawling and serve a noindex, for example.)
Hopefully you will never have to use this, but if you do, it may come in handy.
Forum discussion at Google+.