I'm not sure just what your list consists of. Is it just a succcession
of email addresses separated by commas, e.g.

    j.doe@xyz.zzz.com, p.roe@zzz.com, a.hoe@rrr.org ...

or is it something like this:
    John Doe, j.doe@xyz.zzz.com
   Patricia Roe, p.roe@zzz.com
   Andrew Hoe, a.hoe@rrr.org

or something else? Is it in a Word table, or just in ordinary
paragraphs?

The general idea is to use Word's search-and-replace features to arrange
the list so that there's paragraph (in Word terms) for each address,
with any other fields in the paragraph separated by commas or tab
characters (i.e. as in my second example above).

If the list is in a Word table, use Table|Convert to text to convert it
to ordinary paragraphs. If there are any commas in the data, use tabs to
as separators.

Then delete everything in the document except list, and save it as plain
text without linebreaks. The result should be a file that Access can
import (File|Get External Data).

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.