Another Computer-Related Question (Excel)

Click For Summary

Discussion Overview

This thread discusses various methods for copying and pasting email addresses from an Excel document into an email without retaining the grid lines or table format. Participants share their experiences and techniques for achieving this task efficiently.

Discussion Character

  • Anecdotal
  • Technical explanation

Main Points Raised

  • One participant expresses difficulty in copying email addresses from Excel without including grid lines and seeks assistance.
  • Another participant suggests there might be a way to export the information without spaces but is unsure how to do it.
  • A participant shares a detailed method involving copying the column, pasting it into Word, and converting the table to text for easier email formatting.
  • Another participant mentions using "Paste Special" to paste as unformatted text as an alternative method.
  • Several users express excitement and gratitude for the shared solutions and indicate their intent to try the methods discussed.

Areas of Agreement / Disagreement

Views differ on the best method to copy email addresses from Excel, with multiple techniques presented but no clear consensus on a single preferred approach.

Contextual Notes

The discussion centers around practical experiences with Excel and Word, specifically related to managing email lists for communication purposes.

Who May Find This Useful

Participants within the consultant community who are looking for ways to efficiently manage and utilize email lists from Excel documents.

pamperedbecky
pamperedbecky
Messages
4,441
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! :o 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! :)
 
I think there is a way to export info without the spaces...but I don't know how.
 
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.
 
Another way you can copy without the table is to use "Paste Special" instead of "Paste". Then choose "Unformatted Text".
 
Oooh, an even easier way! Thanks!
 
  • Thread starter
  • #6
Oooh thank you, thank you!! I'm so excited to try this tonight when I have more time! Thanks for your help, you guys!:)
 

Frequently Asked Questions

What is the difference between relative and absolute cell references in Excel?

Relative cell references change when you copy a formula to another cell, while absolute cell references remain constant regardless of where the formula is copied. To create an absolute reference, you use the dollar sign ($) before the column letter and row number (e.g., $A$1).

How can I create a drop-down list in Excel?

To create a drop-down list, select the cell where you want the list, go to the "Data" tab, click on "Data Validation," choose "List" from the "Allow" dropdown, and then enter the items for your list separated by commas or reference a range of cells containing the list items.

What is a pivot table and how do I create one in Excel?

A pivot table is a powerful tool that allows you to summarize and analyze data in Excel. To create one, select your data range, go to the "Insert" tab, click on "PivotTable," choose where you want the PivotTable to be placed, and then drag and drop fields into the Rows, Columns, Values, and Filters areas to organize your data.

How do I use the VLOOKUP function in Excel?

The VLOOKUP function is used to search for a value in the first column of a table and return a value in the same row from a specified column. The syntax is VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]). For example, =VLOOKUP(A1, B1:D10, 2, FALSE) looks for the value in cell A1 within the range B1:D10 and returns the corresponding value from the second column.

What are Excel macros and how do I create one?

Excel macros are sequences of instructions that automate repetitive tasks. To create a macro, go to the "View" tab, click on "Macros," and then select "Record Macro." Perform the actions you want to automate, then stop recording. You can run the macro later from the Macros menu or assign it to a button for easier access.

You must log in or register to reply here.

Similar Pampered Chef Threads

Discontinued Items on Your Website
  • CGutwein
    • Business, Marketing and Customer Service
Replies
2
Views
3K
sharalam
Solve Your Newsletter Frustration: Copy & Paste Pictures to Email Like a Pro!
  • brendaivette
    • Business, Marketing and Customer Service
Replies
2
Views
2K
Admin Greg
Important Reminder: Update Your Custom Host Email Templates Before Thursday
  • dannyzmom
    • Business, Marketing and Customer Service
Replies
2
Views
2K
pamperedharriet
Revamped Special Formats for Improved Securities | Tips and Tricks
  • cookingwithlove
    • Pampered Chef Flyers
2
Replies
42
Views
6K
cookingwithlove
Computer Gurus Need Help Please Re Excel
  • kcjodih
    • Business, Marketing and Customer Service
Replies
7
Views
1K
kcjodih
Easily Import Contacts into PP+ from Excel or Text File
  • kam
    • Business, Marketing and Customer Service
Replies
2
Views
1K
kam
Please Help! Computer Illiterate
  • kcjodih
    • Business, Marketing and Customer Service
Replies
4
Views
2K
3RingChef
Using Adobe Reader 9: How to Copy and Paste Images
  • byrd1956
    • Business, Marketing and Customer Service
Replies
14
Views
3K
raebates
Get Affordable Document Printing with Office Depot FTW!
  • ShelbyMichalek
    • Business, Marketing and Customer Service
Replies
6
Views
2K
littlemaisyPC
Help Needed: Lost Microsoft Word Docs for Conference
  • jdavis
    • Business, Marketing and Customer Service
Replies
7
Views
3K
jdavis
Back
Top