I just had this sprung on me. I need to send an email out to about 40 folks. My boss sent me an excel spreadsheet with their names and email addresses in three seperate columns. The email addresses are all in one column on seperate rows.

How can I snag these addresses? Convert to a comma-delimited file or whatever, then paste into squirrelmail? Cut and paste into a different file format?

Any help will be appreciated.

-JS

4/25/2007 6:51:48 PM

just highlight the column of email addresses, copy and then paste into the To: field of your email message

you shouldn't have to convert or use a different format or do anything else more complicated that copy/paste

[Edited on April 25, 2007 at 6:56 PM. Reason : .]

4/25/2007 6:55:56 PM

select the column with the email addresses.

Control+c

open notepad

control+v


alternatively, save the file as csv

4/25/2007 6:59:03 PM

I've tried the quick cut and paste - it only pastes the first name in the column when I do that

Can someone walk me though the .csv process. What I want to end up with is a text file with a bunch of email addresses seperated by commas and a space (dude@dude.com, werd@were.com, .....)


God, all I want to do is finish this damn busywork and get a beer

4/25/2007 7:07:31 PM

get all the email addresses into one column.

Then go to save as and in the file type chooser pick .csv

4/25/2007 7:31:22 PM

I ended up doing everything by hand (cut/paste/cut/paste repeat ad nausum)

I tried to do exactly what you're talking about (save as .csv), but it didn't want to play pretty and create a .csv file for some reason. I don't know if there is something in the column that is screwing things up, but that miserabe experience is behind me. I've created .csv files before, but for whatever reason this POS didn't want to play pretty.

4/25/2007 7:58:03 PM

VBA allows you to copy data from cells to a variant array at which point you can use the Join() function to delimit the cell values by columns. Would have taken maybe 5 lines of code and 2 minutes.

4/27/2007 8:24:11 PM

use the concatenate formula

go to a blank column. start at the second row with an email address type in: "=concatenate(X1,";",X2)" where x1 is the cell with the first email address, x2 is the cell with the 2nd email address. then drag this formula down to the end

copy the last cell's contents and it should contain: email1;email2;email3...

4/27/2007 9:35:47 PM