1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Email users > Gmail

Discussion in 'Off Topic' started by upnet, Apr 23, 2015.

  1. upnet

    upnet Active Member

    I use the e-mail users feature in ACP to generate a list of e-mails, but it comes out with John Doe johndoe@billbob.com Then when I copy and paste that into gmail I have to go through and remove all the names so it's just e-mail addresses. Has anyone found a workaround for this?
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    Use Excel and the text to columns function.
     
    upnet likes this.
  3. upnet

    upnet Active Member

    Don't have excel but maybe my open office spreadsheet can do it, let's see.
     
  4. Brogan

    Brogan XenForo Moderator Staff Member

    Yes, it should have the same function.
     
    upnet likes this.
  5. upnet

    upnet Active Member

    It does (data > text to columns) but it puts every one in a different column. Then how would I extract every other column to get just the e-mail addresses?

    I'm guessing it's another feature of my pretend excel but I can't figure it out. (Spreadsheet ignorance)
     
  6. Martok

    Martok Well-Known Member

    You should just be able to copy the list from the ACP and paste it into the spreadsheet and it'll separate it into two columns. It works in Excel and I've just tested it in Google Sheets too.
     
    upnet likes this.
  7. upnet

    upnet Active Member

    Yep. Google sheets worked instantly. Thanks Martok and Brogan. Would be nice to just have a checkbox in the e-mail users to either output e-mails or names independently.
     

Share This Page