General Support
Start Topic
KarenH

How to extract all commenter's email address

By KarenH on Sep 19, 2011 at 5:42 AM 1 Vote 0 Votes

I would like to send a bulk email to all who have sent in comments on my blog.

Is there a way to extract or list this information so I can use it in this way?

Thanks!

Reported on Movable Type 4.1x

1 Reply

| Add a Reply
  • Mihai Bocsaru
    Mihai Bocsaru | September 19, 2011 8:13 AM | Reply

    Hi Karen,

    There is no way to do that from inside the movable type admin.

    However, you could do that by connecting to your movable type installation using phpmyadmin and then running the following SQL command:

    SELECT DISTINCT `comment_email`
    FROM `mt_comment`
    WHERE `comment_email` != ''

    Kind Regards,
    Mihai Bocsaru

    ----------------------------------
    Daily Movable Type Consultant

    Web Development
    Movable Type Consulting
    Six Apart Partner

    http://www.pro-it-service.com/
    ----------------------------------

    Movable Type Demo
    http://www.movabletypedemo.org/
    ----------------------------------

    Open Melody Demo
    http://www.openmelodydemo.org/

Add a Reply

If you need to share template code, replace all the "<" signs with "&lt;" or use this utility.

Forum Groups

code.sixapart.com

137 479

Last Topic: Getting a thumbnail with xpath by Peter on Mar 13, 2011

238 797

Last Topic: Manifest Schema Compatibility Issue When Restoring Blog by Matt on Oct 17, 2012

1858 6594

Last Topic: Categories and Basename Publishing Issues by e21media on Oct 25, 2012

88 307

Last Topic: absolute publish date in Manage Entries screen by .mau. on Apr 18, 2012

1488 5347

Last Topic: Anti-cloning by .mau. on Oct 29, 2012

732 3093

Last Topic: Blog moved server - now users cannot access blog? by mowgs on Oct 30, 2012

89 317

Last Topic: How to "pretify" a url in htaccess with a few wildcards by Caio on May 30, 2012

183 771

Last Topic: Commenting with TypePad by Rob Ferrara on Oct 17, 2012

212 680

Last Topic: Does MT-Approval work in MT5? by DLpres on Sep 25, 2012

27 100

Last Topic: Upgrading MT by Caio on Oct 15, 2012

49 224

Last Topic: Movable Type 6 Ideas by Caio on May 28, 2012

65 248

Last Topic: Expanding new rich text editor and implementing table function by Takeshi Nick Osanai on Jul 30, 2012