Results 1 to 7 of 7
  1. #1
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Brooklyn, New York, USA
    Posts
    200
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Convert distribution list to indv. contacts (O 2002)

    Hey everybody - I foolishly made a couple of huge distribution lists with all my friends in them, little thinking I could not send individually to any one person within them, unless I am mistaken! Any clues? Or how I could parse it all out to individual contacts?

    tx

  2. #2
    5 Star Lounger
    Join Date
    Oct 2002
    Location
    Wellington, Wellington, New Zealand
    Posts
    621
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Convert distribution list to indv. contacts (O 2002)

    Naomi

    Yuk. <img src=/S/bummer.gif border=0 alt=bummer width=15 height=15> It can be done via a convoluted route.
    Go to the Calendar and set up a dummy meeting
    Invite a distribution list (under the scheduling tab)
    Expand the list
    The expanded names can then be right-clicked and added to contacts
    Sadly - that's one-by-one

  3. #3
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Brooklyn, New York, USA
    Posts
    200
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Convert distribution list to indv. contacts (O 2002)

    Well at least it's an answer! thanks, gramps kiwi. <img src=/S/yep.gif border=0 alt=yep width=15 height=15>

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

    Re: Convert distribution list to indv. contacts (O 2002)

    An alternative is to export the DL then import that into your contacts. I've attached instructions for the code to export DL entries into Excel. It involves some code, but you just have to copy and paste it from the attached.
    Attached Files Attached Files

  5. #5
    3 Star Lounger
    Join Date
    Jan 2003
    Location
    Den Haag, Netherlands
    Posts
    208
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Convert distribution list to indv. contacts (O 2002)

    Does anybody of you have this solution for Windows XP? (maybe in Dutch?) Because it doesn't work for me... boohoo....

    many thanks in advance!
    Daphne

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Convert distribution list to indv. contacts (O 2002)

    Hello Daphne,

    There were a few problems with OldDog's code. I have attached a cleaned-up version. It works in the Dutch version of Outlook 2002 too.
    You must set a reference to the Microsoft Excel 10.0 Object Library in Tools | References... in the Visual Basic Editor.

    Before running the macro, you must open a distribution list. If all goes well, Excel will be opened, and a workbook listing the names and e-mail addresses of the members of the distribution list.
    Attached Files Attached Files

  7. #7
    3 Star Lounger
    Join Date
    Jan 2003
    Location
    Den Haag, Netherlands
    Posts
    208
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Convert distribution list to indv. contacts (O 2002)

    Many many thanks! I'll get to it right away (on monday! <img src=/S/wink.gif border=0 alt=wink width=15 height=15> )

    Now I'm going to celebrate the weekend!!!

    Bye bye,
    Daphne <img src=/S/thewave.gif border=0 alt=thewave width=225 height=33>

Posting Permissions

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