Can I add multiple contacts from exel/word to Outlook contacts?

  • Thread starter Thread starter Alice-Marie
  • Start date Start date
A

Alice-Marie

I have 300 names in an Excel spreadsheet. I want to send an individual email
message to each. Is there any way to copy multiple contacts into Outlook?
Doing this individually will take forever. Any suggestions? Thanks
 
Use File > Import and Export... to see a list of file types Outlook can
import. You will see that Excel is among them.
 
Russ, why not have the OP do a mail merge and use the Excel spreadsheet as the source?

--
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact.

After furious head scratching, Russ Valentine [MVP-Outlook] asked:

| Use File > Import and Export... to see a list of file types Outlook
| can import. You will see that Excel is among them.
|| I have 300 names in an Excel spreadsheet. I want to send an
|| individual email
|| message to each. Is there any way to copy multiple contacts into
|| Outlook? Doing this individually will take forever. Any
|| suggestions? Thanks
 
That would be fine, but wasn't the question that was asked.
--
Russ Valentine
[MVP-Outlook]
"Milly Staples [MVP - Outlook]" <[email protected]>
wrote in message Russ, why not have the OP do a mail merge and use the Excel spreadsheet as
the source?

--
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact.

After furious head scratching, Russ Valentine [MVP-Outlook] asked:

| Use File > Import and Export... to see a list of file types Outlook
| can import. You will see that Excel is among them.
|| I have 300 names in an Excel spreadsheet. I want to send an
|| individual email
|| message to each. Is there any way to copy multiple contacts into
|| Outlook? Doing this individually will take forever. Any
|| suggestions? Thanks
 
The first question was "I want to send an individual email to each..." - I thought the easiest way was to just use a mail merge.

--
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact.

After furious head scratching, Russ Valentine [MVP-Outlook] asked:

| That would be fine, but wasn't the question that was asked.
| --
| Russ Valentine
| [MVP-Outlook]
| "Milly Staples [MVP - Outlook]"
|
| Russ, why not have the OP do a mail merge and use the Excel
| spreadsheet as the source?
|
|
|| Use File > Import and Export... to see a list of file types Outlook
|| can import. You will see that Excel is among them.
||| I have 300 names in an Excel spreadsheet. I want to send an
||| individual email
||| message to each. Is there any way to copy multiple contacts into
||| Outlook? Doing this individually will take forever. Any
||| suggestions? Thanks
 
I'm not so sure it is the easiest. Have you noticed how many people can't
manage it :)?
I assumed the user actually wanted to import the Excel sheet so they could
use any of the several ways to send to multiple recipients.
--
Russ Valentine
[MVP-Outlook]
"Milly Staples [MVP - Outlook]" <[email protected]>
wrote in message The first question was "I want to send an individual email to each..." - I
thought the easiest way was to just use a mail merge.

--
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact.

After furious head scratching, Russ Valentine [MVP-Outlook] asked:

| That would be fine, but wasn't the question that was asked.
| --
| Russ Valentine
| [MVP-Outlook]
| "Milly Staples [MVP - Outlook]"
| | Russ, why not have the OP do a mail merge and use the Excel
| spreadsheet as the source?
|
|
|| Use File > Import and Export... to see a list of file types Outlook
|| can import. You will see that Excel is among them.
||| I have 300 names in an Excel spreadsheet. I want to send an
||| individual email
||| message to each. Is there any way to copy multiple contacts into
||| Outlook? Doing this individually will take forever. Any
||| suggestions? Thanks
 
Hey! You've been looking over my shoulder!

--
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, Russ Valentine [MVP-Outlook] asked:

| I'm not so sure it is the easiest. Have you noticed how many people
| can't manage it :)?
 
Alice-Marie said:
I have 300 names in an Excel spreadsheet. I want to send an
individual email message to each. Is there any way to copy multiple
contacts into Outlook? Doing this individually will take forever.
Any suggestions? Thanks
Click to expand...

You can use an Excel spreadsheet as a source for addresses using mail merge
in Outlook. No need to transfer the addresses to Outlook first.
 
Back
Top