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

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
> 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.

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?

"KipNowlin" wrote:

> 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

Hi, Mark. You didn't need to "highlight all the email addresses". Just click
anywhere inside the table. Anyway, if you want to mail merge, see if this
article helps:

http://www.officearticles.com/word/m...osoft_word.htm

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

www.OfficeArticles.com


"Mark" <[email protected]> wrote in message
news:[email protected]...
> 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?
>
> "KipNowlin" wrote:
>
> > 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

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

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

Hi, Mark. You didn't need to "highlight all the email addresses". Just click
anywhere inside the table. Anyway, if you want to mail merge, see if this
article helps:

http://www.officearticles.com/word/m...osoft_word.htm

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

www.OfficeArticles.com


"Mark" <[email protected]> wrote in message
news:[email protected]...
> 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?
>
> "KipNowlin" wrote:
>
> > 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?

"KipNowlin" wrote:

> 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

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