default userpic

How to get user registered email and detail?

Vote 0 Votes

I have a blog which use MT. I have alot user registered under my blog. Now I want to extract the user detail to excel format or csv format or other format. So that I can email to all of them using my email. I want to make a celebration dedication to them.

Can anyone here here teach me how to do that?

Reported on Movable Type 4.0x

4 Replies

| Add a Reply
  • you will need to use SQL to do this. This query

    select author_name, author_email from mt_author;
    

    will produce a list of names and email addresses, you should be able to save the results as a csv file or similar in whatever program you use to manage your database.

  • I'd recommend phpMyAdmin.

    In phpMyAdmin, you'd do this:

    1) Run select authorname, authoremail from mt_author; 2) Scroll down to "export" at the bottom of the results page. 3) Export it as a CSV file.

  • Thanks for the reply,

    anyway, where can i find phpMyAdmin? is it built in with MT?

  • No, it's usually provided by your host.

Add a Reply

Forum Groups

151 405

Last Topic: MT Interface Missing by Sherri on Nov 10, 2008

36 144

Last Topic: Installation can't finish by Drazend on Nov 10, 2008

34 93

Last Topic: Creating your own Plug-in by jondauz on Nov 5, 2008

10 33

Last Topic: new licensing confusion by Neil Epstein on Aug 14, 2008

code.sixapart.com

62 226

Last Topic: Callback after blog publishing. by Tomato Interactive on Oct 27, 2008

34 98

Last Topic: Ajax Rating Plugin by kiran on Oct 17, 2008