Anyone here any good with MS Excel ??? - HotUKDeals
We use cookie files to improve site functionality and personalisation. By continuing to use HUKD, you accept our cookie and privacy policy.
Get the HUKD app free at Google Play

Search Error

An error occurred when searching, please try again!

Login / Sign UpSubmit

Anyone here any good with MS Excel ???

kyalion Avatar
8y, 2w agoPosted 8 years, 2 weeks ago
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.
Other Links From Here:
kyalion Avatar
8y, 2w agoPosted 8 years, 2 weeks ago
Options

All Comments

(29) Jump to unreadPost a comment
Comments/page:
#1
sorry so are you asking on how to save it as a .csv file?
#2
File > Save As... Pick csv (Comma Separated Values) from the File Type dropdown job done.
#3
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.
#4
Surely you would just save it as the file type you want?
#5
Abz
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?
#6
megalomaniac
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#7
Babbabooey;3504681
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#8
kyalion;3504698
Tried that, but .csv is not there as an option.

What version you using?
#9
kyalion
Tried that, but .csv is not there as an option.


What version of Excel?
#10
Babbabooey
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.
#11
Babbabooey
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
#12
would help if you state what version your using
#13
what version of Office?
#14
What he's saying makes sense. Just save as .csv then open with something like notepad and copy it out into your email
#16
kyalion
Tried that, but .csv is not there as an option.


Titchimp
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.
#17
when you click the drop down for 'save as type' you are scrolling down through the list of available formats aren't you?
1 Like #18
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.
#19
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
#20
chrishill
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
#21
BTW you don't even have to do that, just select all the email addresses and cut & paste them into the bcc field
#22
alanrowell
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:
#23
AberBargoed
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.
#24
alanrowell
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.
#25
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.
#26
kyalion
GENIUS :thumbsup:
Thanks soooooo much. Rep added.


NP -glad to have been of help :)
#27


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:
#28
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#29
kyalion;3505062
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

You don't need an account to leave a comment. Just enter your email address. We'll keep it private.

...OR log in with your social account

...OR comment using your social account

Thanks for your comment! Keep it up!
We just need to have a quick look and it will be live soon.
The community is happy to hear your opinion! Keep contributing!