Move a Column of 500 Email Addresses into BCC Field of an Email

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to take a column of email addresses on a spreadsheet and make them
available as recipients of a mass email I am planning. Is there any way to
do this importing to my Outlook Contact, then creating a Group List. I don't
want these 500 as a permanent addition to my Contacts. Just want them for
the mass email.
 
Here's how I'd do it, Mark. Copy the column, paste into Word. Do a
Table-->Convert-->Table to text and choose a ; (semicolon) as the delimiter.
:)
Copy the text you get and paste into your BCC.

*******************
~Anne Troy

www.OfficeArticles.com
 
Mark,

Anne has a great solution. You can also leave them in Excel and create a
Word Merge in Word and select "E-mail Messages". This lets you create a
standard message for all recipients, and if you choose, you can personalize
each one. Any of the columns in your spreadsheet can also be merge fields.

Kip
 
Kip -
I tried Anne's solution but, after I highlighted all the email addresses in
Word, my only option was Table, Convert, Text to Table. Table to Text is
dimmed.
I actually prefer your solution because I would indeed like to personalize
each one at least with a changing name at beginning of body of each email, if
it can be done easily. Can you explain how I leave them in Excel and create
the word merge you mention?
 
Mark....

Your Table to Text may have been grayed out because you had highlighted text
outside of the table. That is a common error.

The article Anne referred to is what I do. There is an incomplete sentence
in it that I didn't understand, but the gist of it is there. The only other
thing I do is to insert other merge fields from the spreadsheet. This only
refers to the address block (or the individual fields), but not other fields.
Those are important to me in most of the mass e-mailing I do.

Good Luck with this.

Kip
 
(1) I was able to load my BCC field with the pasted Excel email addresses,
but it loads vertically in BCC, just like my Excel column, and did not
convert to the usual email field horizontally. Will these still send OK?
Also, vertical field retained spaces between some, just as my Excel list did,
because not all names from original Excel list had email addresses associated
with them. Is this a problem for the send as well?
(2) Even better, I was able get everything into Mail Merge, with a separate
document ready to send for each email addressee. To send them, I tried
File/Send to: Mail Recipient. Got this Error Message: "Word could not load
the e-mail envelope. This could be caused by a network connection problem or
a problem with your Office Installation." I use Outlook for my Email and
have not had a problem before. So -- how do I send this great mass email now?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Locate data from 1 column in another 2
Email addresses in Excel need to format for mass email 1
sending to multiple contacts like BCC 2
BCC bulk addition of Addresses 2
text to column 6
Concatenate email addresses 3
How do I export a row of data into its own workbook 1
Changing "From" Email address based upon "To" 0

Back
Top