Using a spread sheet for e-mail addresses

  • Thread starter Thread starter Len Urban
  • Start date Start date
L

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
 
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
 
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
 
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
 
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
 
Thanks Peter:

This worked

Len
Peter Durkee said:
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
Click to expand...
 
Back
Top