Close this search box.

Yahoo Mail Question

I switched from Yahoo Mail to Gmail a long time ago, but I still get dozens of emails a day sent to my old Yahoo email address. I forward them to Gmail, but I\’d like to make sure my 2,600 contacts in my Yahoo Address Book and many thousands of other people who have emailed me in the past know my new email address.

I\’ve avoided using Plaxo just because it annoys me so much when other people use it. I love because the email addresses of my 480+ contacts there get updated automatically whenever they update their profile. Maybe I should use Plaxo, but I\’m looking for another solution.

Does anyone know how I can email not only the contacts in my Yahoo Address Book but also the thousands of others with whom I have corresponded in Yahoo Mail, whom I haven\’t added to my Address Book?

I\’ve been looking for some kind of email harvest tool, but every one I found works primarily on external web sites and won\’t allow me to legitimately harvest my own email contacts in my own personal address book?

That is my first question.

My second question is how do I harvest all the email addresses from people who have posted comments on my personal blog? I\’d like to invite them to listen in on a free conference call and possibly join an online network of entrepreneurs in an exclusive private forum. I certainly don\’t want to collect their email addresses on at a time. I use WordPress 2.03, and I read something about a MySQL query that could give me access to the email addresses of the commenters, but I don\’t know more than that.

That is my second question.

Finally, how should I get around the Yahoo Mail limit of 100 emails sent at a time? To notify all my legitimate contacts that my email address has changed, I\’ll need to send about 5-6,000 emails out, and I don\’t want to do them in batches of 100.

That is my third question.

Any suggestions from all of the wonderful people out there?

6 thoughts on “Yahoo Mail Question

  1. Paul:

    Nice conference call today, thanks for sharing so freely your ideas and experiences.

    For WordPress, you can just do an SQL query from your favorite database interface application:

    select distinct(comment_author_email) from wp_comments

    The “wp_” may differ depending on your setup, but that is the default I think.

  2. Import the addresses into a Yahoo Group and email them that way? You might also set up a free personal account and import the addresses, then use the “keep in touch” feature, assuming it is available in the free version.

    Log into php-my-admin, it (or something similar)should come with your hosting account. It’s a GUI interface to your mysql database. If you are careful you should be able to click through to find the email address table, and then export it as a csv file.

    Yahoo Groups solves question 3 too.

    5000 email addresses? Wow…

  3. I echo Michael’s comment about yesterday’s conference call. Plus, I’d like to get my email address in your wordpress database before you harvest the emails 🙂

  4. You don’t need to send email through Yahoo Mail for it to come from your Yahoo email account. You can use a PHP mail script, for example, to send 6000 emails that have your Yahoo email address as the From address (and Reply To address). To the recipients, the email will look just like it came from your Yahoo account, but you won’t have the 100-email limit.

    The only downside is the 6000 emails won’t be saved to your Yahoo Mail Sent Items folder.. but then again, that might be a plus.

  5. This sql will give you the email addresses…
    SELECT DISTINCT `comment_author_email` , `comment_author`
    FROM `wp_comments`
    WHERE comment_author_email != ”

    If you’re using phpMyAdmin, you can export those results as a CSV or EXCEL file.

Leave a Reply


More Posts Logo Design

Some of you know that my partners and I are launching a new company that aims to help a billion or more people soar with

Cold Showers Can Benefit Your Health

I hated what I read in the Harvard Business Review last Friday: Cold showers have health benefits. I’ve always ignored people who advocate taking cold

People Like Me Need People Like You

“People Like Me Need People Like You” Someday I’ll write a book about I’ll highlight the people who built Ancestry from the ground up–unsung

The Team Coaching Zone Podcast

To listen to this podcast, click HERE. Announcer: Welcome to the Team Coaching Zone podcast. Join your host Dr. Krister Lowe and today’s leading organizational

My Favorite Artist

Artists, poets, and prophets can help us make sense of the craziness that we experience in the world. My favorite artist is Regina Spektor. When

The Coach You Need

When you need a helping hand in life or at work you might decide to hire a coach. There are many amazing executive, career, leadership,

Beware of Taking Advice

Next Friday I get to deliver a keynote at Phoenix’s biggest startup event. But beware of taking advice from me–or anyone else. Startup events are

An Entrepreneurial Superpower

One of my entrepreneurial superpowers is asking questions at scale. Before I started Ancestry I went to libraries and conferences and asked questions. I learned

Paul hopes to bring the strengths message to all 50 states and to 50 countries by 2025.
Contact him so he can help you spark a strengths movement in your area, company, or industry.