Create distribution list in Outlook from Excel spreadsheet?
m wrote:
1) Can an Outllook DL created directly, either by the copy-paste
procedure you suggest or by keying email addresses directly in the
DL's Members list, rather than created by selecting already-existing
Outllook contacts, be exported to a file for use by other people? If
so, how? In my tries so far, such exported files (in Excel or CSV
format) have omitted all distribution lists.
ARe these other people also using Exchange? If so, of course. If not, then
you can export it as a text file with will look like this:
Distribution List Name: yourlistname
Members:
member one address
member two address
member three address
with a tab between the member name and the address.
--
Brian Tillman
2) Can I import address/contact data from Excel (or CSV file) into a
separately-named Outlook address/contacts folder rather than to the
general Contacts folder? If so, how? Outlook doesn't seem to allow
selecting a particular destination contacts folder for imported data.
3) Considering that Outlook does allow opening a .pst file with
address/contacts data into a separately named contacts folder, can the
current Excel file be converted into a .pst file either directly or
via an intermediate CSV file? If so, how?
Thanks for all help.
"Brian Tillman" wrote:
Bruce wrote:
What I want to do is generate a distribution list in Outlook without
having to start from scratch and select each name in the Address
Book. Can this be done?
If you have a semicolon-separated list of addresses in a text file,
you can open a new DL, click "Select Members", then open the address
list file and copy-and-paste the list into the Members field in the
address book window. Click OK and they'll be added to the DL. I've
done it so I know it works. It may also work with a comma-separated
list, but I haven't tried that. --
Brian Tillman
|