Another Computer-Related Question (Excel)

[pamperedbecky]

I hope someone can help me out. I know there are a bunch on here who are VERY computer-literate......

I'm not too familiar with Excel. I pretty much know the basics, but I'm trying to do something that I'm not sure can be done. I have a list of brides from a recent bridal expo I did. This is a list that the organizers of the event emailed me with each bride's info in an Excel document. One of the columns is their email address. I was hoping there's a way to copy and paste this whole list of addresses so I can then paste it onto the BCC line to send out an email to everyone. I thought I could copy and paste the column to a Word document, then save it for easy reference later, then copy and paste it again to the email line. Everytime I try to copy and paste to the word document, it shows up with all the grid lines and it won't paste the whole list without those lines.

I hope this is making sense to someone! If anyone is more familiar with Excel, is this something I can even do instead of copying and pasting each individual email? Thanks in advance for any help! I appreciate it!

 

[tashayoung]

I think there is a way to export info without the spaces...but I don't know how.

 

[jenniferp417]

Yes! I know how! I don't know how to do much in excel and word, but I know this!Copy the column.
Paste it into word.
select it all again if it's not still hightlighted - but JUST the table, not the whole page
go to the table menu
find the convert option (you might need to click the little arrow at the bottom of the table menu if you have a later version that hides some options
choose convert and then "table to text"
in the little box that pops up, choose "paragraph marks"
Voila!BUT you need them in one long line, not a column, right?I can do that too!hold down your CTRL key and press H. That brings up your "find and replace"
type ^p in the find box - that finds the line endings
type , (a comma and a space) in the replace box
click "replace all"Mine had some extra commas at the end to delete, but other than that, there you are! the perfect list for copying into your email program!Let me know if I left out a step or you need more help.

 

[strasfamily]

Another way you can copy without the table is to use "Paste Special" instead of "Paste". Then choose "Unformatted Text".

 

[jenniferp417]

Oooh, an even easier way! Thanks!

 

[pamperedbecky]

Oooh thank you, thank you!! I'm so excited to try this tonight when I have more time! Thanks for your help, you guys!