Can this be done? So I want to download all users email addresses so I can send them an email. I know I can do this through the admin back end but I want to use mailchimp to send this particular email. So want to export them out of xenforo.
So I copied and pasted that into excel which drops them into one column each on separate rows going down. Each cell contains the email address and the users name all together so have to separate the email address out manually or use this code in the column next to it and that will chuck out just the email address for you! Remember to click into the cell and then paste this code in first.