export email, ip address and date stamp

I need to somehow get a spreadsheet with all of our customers for the following fields: email, ip, date stamp.

anyone know how to do this? I don't know if there is anything built into the admin to do it, so maybe it will work in phpmyadmin - but I am unsure the exact query to pull this info and also what the exact DB fields are.

Thanks!

Why ?

IP addresses aren't stored as part of customer details.
Date stamps stored may not be the same as what you're "wanting", but since you didn't explain why, it's hard to tell you whether you can have it or not.

I want to do it because we have 33,000+ customers that I want to email, but don't want to email them from our server.

I wanted to import them into our getresponse account, but they require ip and datestamp, otherwise they will send a confirmation to every email, which I would rather not do.

I see the IP is in the order emails, but it isn't saved, so I am unsure how to get it all

I guess you could pull the ip_address and date_purchased and customers_email_address from the orders table, and that would give you the details of customers who have bought something at least once. If you want details of customers including those who've not made a purchase, you can pull the customers_email_address from the customers table and the last_login_date from the customers_info table, but skip the IP address. You might give some consideration to whether the customer has elected to be included in your newsletter mailings as part of their account preferences, as reflected as a "1" in the customers_newsletter field of the customers table