import email addresses into a distribution list

H

hockey2014

Is it possible to copy multiple email addresses from either a Word or Excel
document into an Outlook Distribution List without having to enter each
email address individually into Outlook & then into a Distribution List?
 
B

Brian Tillman [MVP - Outlook]

Is it possible to copy multiple email addresses from either a Word or Excel
document into an Outlook Distribution List without having to enter each
email address individually into Outlook & then into a Distribution List?

Yes, (and from a Notepad or Wordpad doucment as well) provided the addresses
are presented in the correct form. Ther must be one address or one
name/address pair per line, like this:

address1
address2
address3
....etc...

or

Name1 Address1
Name2 Address2
....etc...

They can also be all on one line and separated by semicolons, like this:

address1; address2; address3; ...

or

Name1 address1; Name2 address2; Name3 address3; ...

In Outlook click File>New>Distribution List. When the form opens, give it a
name and then click Select Members. Now open the document containing the
members you wish to add. Select them, then right-click the selection and
click Copy. Go back to the Select Member dialogue, right-click in the Members
field and select Paste. Click OK. The DL will populate and you can then
click Save and Close.

On the whole, however, it's usually better to add them to your Contacts folder
and use a category to reporesent the list instead of using a DL.
 
H

hockey2014

Thanks.....it worked..

Brian Tillman said:
Yes, (and from a Notepad or Wordpad doucment as well) provided the addresses
are presented in the correct form. Ther must be one address or one
name/address pair per line, like this:

address1
address2
address3
....etc...

or

Name1 Address1
Name2 Address2
....etc...

They can also be all on one line and separated by semicolons, like this:

address1; address2; address3; ...

or

Name1 address1; Name2 address2; Name3 address3; ...

In Outlook click File>New>Distribution List. When the form opens, give it a
name and then click Select Members. Now open the document containing the
members you wish to add. Select them, then right-click the selection and
click Copy. Go back to the Select Member dialogue, right-click in the Members
field and select Paste. Click OK. The DL will populate and you can then
click Save and Close.

On the whole, however, it's usually better to add them to your Contacts folder
and use a category to reporesent the list instead of using a DL.
 
J

Jo Foster

I'm sort of trying to do the opposite: in category view, copying list of
names (and emails if possible ) into a Word document. one name at a time is
difficult enough
 
B

Brian Tillman [MVP - Outlook]

I'm sort of trying to do the opposite: in category view, copying list of
names (and emails if possible ) into a Word document. one name at a time is
difficult enough

I find it faily easy to export the entire Contacts folder to an Excel file,
mapping the fields I need, but making sure I include the Categories field. I
can then open the Excel file, sort by the Categories column, and delete
anything not in the category I want.
 

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

Top