Using a spread sheet for e-mail addresses

[Len Urban]

I have a large number of e-mail addresses in a spread sheet column. Is there
a way to copy the e-mail addresses into the To box (bcc) of an outgoing
e-mail without first installing them in my contacts folder?

Thanks,

Len Urban

 

[Peter Durkee]

Save the column as a text file, open the file in Word or your favorite text
editor, replace all the line endings with semicolons, and paste it all into
the BCC field.

-Peter

 

[Milly Staples [MVP - Outlook]]

Simply perform a mail merge and specify your datasheet as the source for addressing.

--
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
reading.

After furious head scratching, Len Urban asked:

| I have a large number of e-mail addresses in a spread sheet column.
| Is there a way to copy the e-mail addresses into the To box (bcc) of
| an outgoing e-mail without first installing them in my contacts
| folder?
|
| Thanks,
|
| Len Urban

 

[Len Urban]

OK Milly

I'm one of the slow students. Furious head scratching was of no avail.

I go to send an e-mail. Check Bcc, select tools, then letters and mailings
the mail merge is not highlighted as an option??

Len

"Milly Staples [MVP - Outlook]"
Simply perform a mail merge and specify your datasheet as the source for
addressing.

--
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
reading.

After furious head scratching, Len Urban asked:

| I have a large number of e-mail addresses in a spread sheet column.
| Is there a way to copy the e-mail addresses into the To box (bcc) of
| an outgoing e-mail without first installing them in my contacts
| folder?
|
| Thanks,
|
| Len Urban

 

[Milly Staples [MVP - Outlook]]

http://www.outlook-tips.net/howto/mailmerge_tools.htm

--
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
reading.

After furious head scratching, Len Urban asked:

| OK Milly
|
| I'm one of the slow students. Furious head scratching was of no avail.
|
| I go to send an e-mail. Check Bcc, select tools, then letters and
| mailings the mail merge is not highlighted as an option??
|
| Len
|
| "Milly Staples [MVP - Outlook]"
| | Simply perform a mail merge and specify your datasheet as the source
| for addressing.
|
| --
| Milly Staples [MVP - Outlook]
|
| Post all replies to the group to keep the discussion intact. All
| unsolicited mail sent to my personal account will be deleted without
| reading.
|
| After furious head scratching, Len Urban asked:
|
|| I have a large number of e-mail addresses in a spread sheet column.
|| Is there a way to copy the e-mail addresses into the To box (bcc) of
|| an outgoing e-mail without first installing them in my contacts
|| folder?
||
|| Thanks,
||
|| Len Urban

 

[Len Urban]

Thanks Peter:

This worked

Len

Save the column as a text file, open the file in Word or your favorite
text editor, replace all the line endings with semicolons, and paste it
all into the BCC field.

-Peter