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.