Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Jul 2001
    Location
    Terneuzen, Netherlands
    Posts
    895
    Thanks
    0
    Thanked 0 Times in 0 Posts

    DL creation from EXCEL (2000)

    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

  2. #2
    5 Star Lounger
    Join Date
    May 2001
    Location
    Washington, USA
    Posts
    750
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: DL creation from EXCEL (2000)

    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.
    Attached Files Attached Files

  3. #3
    5 Star Lounger
    Join Date
    Jul 2001
    Location
    Terneuzen, Netherlands
    Posts
    895
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: DL creation from EXCEL (2000)

    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)...

  4. #4
    Lounger
    Join Date
    May 2002
    Location
    Provo, Utah, USA
    Posts
    32
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: DL creation from EXCEL (2000)

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •