Creating distribution list from Excel data base

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm coordinating an event that folks register for on-line. The registration script generates a new Excel Spreadsheet which is e-mailed to me on a regular basis. One of the columns in the spreadsheet contains the list of e-mail addresses. Is there a way to quickly create a distribution list from this column of data in my Contacts folder without entering them one by one

The data in the spreadsheet is not time stamped so I don't have a way of knowing who was registered yesterday as opposed to today so I really can't maintain a distribution list, but as long as I have a quick and dirty way to create a new distribution list from Excel it doesn't matter

Thanks

-mat
 
You'd have to write code to create a new DL. Why not just import to a
separate contacts folder? DLs that change frequently are often more trouble
than they are worth to maintain.
--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers



I'm coordinating an event that folks register for on-line. The registration
script generates a new Excel Spreadsheet which is e-mailed to me on a
regular basis. One of the columns in the spreadsheet contains the list of
e-mail addresses. Is there a way to quickly create a distribution list from
this column of data in my Contacts folder without entering them one by one?

The data in the spreadsheet is not time stamped so I don't have a way of
knowing who was registered yesterday as opposed to today so I really can't
maintain a distribution list, but as long as I have a quick and dirty way to
create a new distribution list from Excel it doesn't matter.

Thanks,

-matt
 
Back
Top