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

Email users > Gmail

upnet

Active member
#1
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?
 

upnet

Active member
#5
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)
 

Martok

Well-known member
#6
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

Active member
#7
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.