Anyone here any good with MS Excel ???

29 replies
Found 19th Nov 2008
Basically, this is something I need to do for work.

I have a list of about 280 e-mails in an Excel doc that I need to send as a mass e-mailer through my work e-mail address. I have been told to convert it to a .csv file so I can then copy and paste into the BCC line. The ISP I use for my e-mail is Gmail.

Hopefully this will make sense to someone out there.

I will be eternally grateful for any advice, and will obviously rep where I can.

29 Comments

sorry so are you asking on how to save it as a .csv file?

File > Save As... Pick csv (Comma Separated Values) from the File Type dropdown job done.

You dont need to do anything if you're using Office 2007... Assuming all the emails are listed in separate cells then just select all and copy, then paste into your email BCC line and press CTRL-K to check addresses, and they should all be fine.

Surely you would just save it as the file type you want?

Original Poster

Abz;3504633

sorry so are you asking on how to save it as a .csv file?



I think so. :oops:

Basically, all the contacts are listed down in column A. Rather than copy and pasting all 280 of them into the BCC line of my address bar, I was told by a colleague (now doubting his ability) that if I saved the file as a .csv file I could then do one huge copy and paste into the BCC line.

Does that make more sense?

Original Poster

megalomaniac;3504676

File Save As... Pick csv (Comma Separated Values) from the File Type … File > Save As... Pick csv (Comma Separated Values) from the File Type dropdown job done.



Tried that, but .csv is not there as an option.

Banned

Babbabooey;3504681

You dont need to do anything if you're using Office 2007... Assuming all … You dont need to do anything if you're using Office 2007... Assuming all the emails are listed in separate cells then just select all and copy, then paste into your email BCC line and press CTRL-K to check addresses, and they should all be fine.


agreed

Banned

kyalion;3504698

Tried that, but .csv is not there as an option.


What version you using?

kyalion;3504698

Tried that, but .csv is not there as an option.



What version of Excel?

Babbabooey;3504681

You dont need to do anything if you're using Office 2007... Assuming all … You dont need to do anything if you're using Office 2007... Assuming all the emails are listed in separate cells then just select all and copy, then paste into your email BCC line and press CTRL-K to check addresses, and they should all be fine.



I just tried in Office 2003 and it works there too by the way.

Original Poster

Babbabooey;3504681

You dont need to do anything if you're using Office 2007... Assuming all … You dont need to do anything if you're using Office 2007... Assuming all the emails are listed in separate cells then just select all and copy, then paste into your email BCC line and press CTRL-K to check addresses, and they should all be fine.



If only :whistling:
Using Windows 2000 and Excel 2000

would help if you state what version your using

what version of Office?

What he's saying makes sense. Just save as .csv then open with something like notepad and copy it out into your email

I dunno if that works with 2000, but im on 2007 here so if you wanna email the xls over ill save it as a csv and send you that back.

depends how confidential these email address are...... [email protected]?

kyalion;3504698

Tried that, but .csv is not there as an option.



Titchimp;3504752

What he's saying makes sense. Just save as .csv then open with something … What he's saying makes sense. Just save as .csv then open with something like notepad and copy it out into your email



The thing is he is saying .csv is not an option which seems a bit strange.

when you click the drop down for 'save as type' you are scrolling down through the list of available formats aren't you?

Could try this. Are these all in one column? Select the list of email addresses, then open Word and copy the list from excel using Paste Special/Unformatted text. Once you have the list in Word open the control/replace box (Ctrl + F) and in the Find What box enter ^p (^ and small p) & in the Replace box enter , (comma followed by a space). Press Replace All. You should then be able to copy and paste the new format into your email BCC box.

I doubt if there is a spreadsheet in the world that doesn't allow saving as a .csv file - let alone Excel 2000

You aren't looking at all the "save as" options, you need to go down the drop down list as there's more than half a dozen

Original Poster

chrishill;3504808

when you click the drop down for 'save as type' you are scrolling down … when you click the drop down for 'save as type' you are scrolling down through the list of available formats aren't you?



Yes, and all sorts of file types, but not a single .csv option

BTW you don't even have to do that, just select all the email addresses and cut & paste them into the bcc field

alanrowell;3505002

BTW you don't even have to do that, just select all the email addresses … BTW you don't even have to do that, just select all the email addresses and cut & paste them into the bcc field



Already said in post 4, waiting to hear if it worked :thumbsup:

Original Poster

AberBargoed;3504943

Could try this. Are these all in one column? Select the list of email … Could try this. Are these all in one column? Select the list of email addresses, then open Word and copy the list from excel using Paste Special/Unformatted text. Once you have the list in Word open the control/replace box (Ctrl + F) and in the Find What box enter ^p (^ and small p) & in the Replace box enter , (comma followed by a space). Press Replace All. You should then be able to copy and paste the new format into your email BCC box.



GENIUS :thumbsup:
Thanks soooooo much. Rep added.

Original Poster

alanrowell;3505002

BTW you don't even have to do that, just select all the email addresses … BTW you don't even have to do that, just select all the email addresses and cut & paste them into the bcc field



Tried that and it doesn't comma seperate them. Tested it on 3 or 4 e-mails and they bounced back as undeliverable.

If you want email me the spreadsheet and ill sort it for you. And then send you back the file with the email addresses sorted out.

kyalion;3505046

GENIUS :thumbsup:Thanks soooooo much. Rep added.



NP -glad to have been of help

Original Poster

MinstrelMan;3504769

I dunno if that works with 2000, but im on 2007 here so if you wanna … I dunno if that works with 2000, but im on 2007 here so if you wanna email the xls over ill save it as a csv and send you that back.depends how confidential these email address are...... [email protected]?



I appreciate the offer, but as you can imagine I'm e-mailing them as BCC, so it wouldn't be a good career move to e-mail them out of the business. Would be like stumbling across the BNP listings :whistling:

if all the email addresses are in individual cells then all you have to do is write a small macro to parse thru the cells and copy each email address into a string variable and separate them with a comma or semi colon. Then at the end of the loop write the string variable value to one cell. This should be a complete list of all email addresses separated so that all you have to do is copy and paste it in to the BCC box in the email?

:thumbsup:

Banned

kyalion;3505062

Tried that and it doesn't comma seperate them. Tested it on 3 or 4 … Tried that and it doesn't comma seperate them. Tested it on 3 or 4 e-mails and they bounced back as undeliverable.


should have just put a comma in column B and replicated for each of the 280 cells. Then copy and paste all of column A & B to the BCC field.
Post a comment
Avatar
@
    Text
    Top Discussions
    1. Without giving away your age, name three things that remind you of when you…4176
    2. I want to talk about the WEATHER no politics no religion19247616
    3. Limited quantities of STRAFE® and SHADOW WARRIOR 2 for sale @ Special Reser…46
    4. Smacking children is to be banned in Scotland3275

    See more discussions