DL creation from EXCEL (2000)

Topic

New Reply

I’m looking for some VBA code that allows me to build an Outlook distribution-list from User-ID’s listed in rows in an EXCEL sheet… Looked around a bit but couldn’t find anything quickly… Any tips, code snippets?

Thanks,

Erik Jan

Reply | Quote

Replies

Attached is a worksheet that should do what you need. Should be close anyway, and you can tweak it if need be. It’s been posted before, but in this iteration I’ve commented out version checking code that caused it to break when run in XP.

Reply | Quote

Thanks, I did play around with this a bit and found out it will get names from a DL (and -optionally-) also their calender info; nice code!

However, I was actually looking for a way to create a (local) DL from rows in EXCEL (so the opposite from what this code does)…

Reply | Quote

I know this isn’t an answer to your question, but I just had somone ask me how to do this in the office and I thought it might be worth it to post here. If you want to add people to a distribution list by copy and paste from an Excel spreadsheet, it is possible, but not obvious. Also, these steps are for 2002, but I don’t think they are much different for 2000.

So for those of you that are willing to accept the manual process rather than the VBA script, here we go.

To add multiple people to a distribution list all at once:
1. Create a new Distribution list with File–>New–>Distribution List
2. Give a name to the list in the Name field, such as the name of the class.
3. Click the button Select Members…
4. In the dialog box that appears, click your mouse in the region marked “Add to Distribution List”.
5. You can enter email addresses here by hand, or you can copy and paste a column of email addresses from Excel. Each address will be on a new line.
6. Click OK.

The trick is knowing where to paste the names which is what baffled the person I was helping. That box doesn’t look like something that is normally editable by direct typing.

Bradley Ross

Reply | Quote