Email users > Gmail

[upnet]

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?

 

[Paul B]

Use Excel and the text to columns function.

 

[upnet]

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

 

[Paul B]

Yes, it should have the same function.

 

[upnet]

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]

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]

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.