I have a distribution list that displays the aliases - I want to pull just
the email address so that I end up with (example):

joe@ms.com,jane@ms.com,trudy@ms.com,james@ms.com


Is this possible?

Re: Extract delimted list of email addresses from a distribution list? by Diane

Diane
Tue Jul 29 11:56:28 PDT 2008

Not sure if this works in other versions - but in Outlook 2007, open the DL
and choose Send... in internet format. The new message will have a text
attachment with the display names and email addresses. You can also save as
text or rtf file. They'll be in column format - you'll need to work them in
word or Excel to remove the display names and comma delimit the addresses.

If that is not an option in your version - these are other methods:
if you received a copy of a message to the DL, check the header and with
some effort cleaning it up, you could get the addresses from the internet
header.

Print to an electronic format and OCR it. If you use Acrobat, print to it
and copy the addresses using the text tool. You'll need to clean the file
up to remove the display names. (The fastest way seems to be to crop it so
just the addresses are in the file then OCR or whatever.)



--
Diane Poremsky [MVP - Outlook]
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:
dailytips-subscribe-request@lists.outlooktips.net

EMO - a weekly newsletter about Outlook and Exchange:
EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH.EASE.LSOFT.COM

Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com

You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point your
newsreader to msnews.microsoft.com.


"Vorv" <Vorv@discussions.microsoft.com> wrote in message
news:CF0FF44E-5CEA-4AD3-B26D-4E143706A901@microsoft.com...
> I have a distribution list that displays the aliases - I want to pull just
> the email address so that I end up with (example):
>
> joe@ms.com,jane@ms.com,trudy@ms.com,james@ms.com
>
>
> Is this possible?
>

Re: Extract delimted list of email addresses from a distribution l by Vorv

Vorv
Tue Jul 29 12:43:01 PDT 2008

Thanks Diane.

I use 2007, but can't find the "send in internet format" option.

I have done the following:

opened a new email, typed in the DL and expanded it to show all the aliases.
Chose "save as" text, but the file just gave me the aliases in plain text.
No email addresses.

I feel like I'm almost there... any other insight would be appreciated!

PV

"Diane Poremsky [MVP]" wrote:

> Not sure if this works in other versions - but in Outlook 2007, open the DL
> and choose Send... in internet format. The new message will have a text
> attachment with the display names and email addresses. You can also save as
> text or rtf file. They'll be in column format - you'll need to work them in
> word or Excel to remove the display names and comma delimit the addresses.
>
> If that is not an option in your version - these are other methods:
> if you received a copy of a message to the DL, check the header and with
> some effort cleaning it up, you could get the addresses from the internet
> header.
>
> Print to an electronic format and OCR it. If you use Acrobat, print to it
> and copy the addresses using the text tool. You'll need to clean the file
> up to remove the display names. (The fastest way seems to be to crop it so
> just the addresses are in the file then OCR or whatever.)
>
>
>
> --
> Diane Poremsky [MVP - Outlook]
> Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
> Outlook 2007: http://www.slipstick.com/outlook/ol2007/
>
> Outlook Tips by email:
> dailytips-subscribe-request@lists.outlooktips.net
>
> EMO - a weekly newsletter about Outlook and Exchange:
> EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH.EASE.LSOFT.COM
>
> Outlook Tips: http://www.outlook-tips.net/
> Outlook & Exchange Solutions Center: http://www.slipstick.com
>
> You can access this newsgroup by visiting
> http://www.microsoft.com/office/community/en-us/default.mspx or point your
> newsreader to msnews.microsoft.com.
>
>
> "Vorv" <Vorv@discussions.microsoft.com> wrote in message
> news:CF0FF44E-5CEA-4AD3-B26D-4E143706A901@microsoft.com...
> > I have a distribution list that displays the aliases - I want to pull just
> > the email address so that I end up with (example):
> >
> > joe@ms.com,jane@ms.com,trudy@ms.com,james@ms.com
> >
> >
> > Is this possible?
> >
>

Re: Extract delimted list of email addresses from a distribution list? by Michael

Michael
Tue Jul 29 13:10:52 PDT 2008



You can save the item as a txt file, and open that in Excel, then it's easy
to delete everything you don't need, and save the item again.

--
Best regards
Michael Bauer - MVP Outlook

: VBOffice Reporter for Data Analysis & Reporting
: Outlook Categories? Category Manager Is Your Tool
: <http://www.vboffice.net/product.html?pub=6&lang=en>


Am Tue, 29 Jul 2008 11:22:34 -0700 schrieb Vorv:

> I have a distribution list that displays the aliases - I want to pull just
> the email address so that I end up with (example):
>
> joe@ms.com,jane@ms.com,trudy@ms.com,james@ms.com
>
>
> Is this possible?

Re: Extract delimted list of email addresses from a distribution l by Diane

Diane
Tue Jul 29 19:06:16 PDT 2008

Open the DL form. Under the office icon is the save and close button, Send
button with dropdown, and Delete. Click the Send button and choose internet
format. This creates a new message with a text attachment. Open the
attachment and close the new message. you'll need to work the text to make
it delimited, there is no way around that.

--
Diane Poremsky [MVP - Outlook]
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:
dailytips-subscribe-request@lists.outlooktips.net

EMO - a weekly newsletter about Outlook and Exchange:
EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH.EASE.LSOFT.COM

Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com

You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point your
newsreader to msnews.microsoft.com.


"Vorv" <Vorv@discussions.microsoft.com> wrote in message
news:99B769DE-19F7-406F-A4BF-1E96BE7176EA@microsoft.com...
> Thanks Diane.
>
> I use 2007, but can't find the "send in internet format" option.
>
> I have done the following:
>
> opened a new email, typed in the DL and expanded it to show all the
> aliases.
> Chose "save as" text, but the file just gave me the aliases in plain text.
> No email addresses.
>
> I feel like I'm almost there... any other insight would be appreciated!
>
> PV
>
> "Diane Poremsky [MVP]" wrote:
>
>> Not sure if this works in other versions - but in Outlook 2007, open the
>> DL
>> and choose Send... in internet format. The new message will have a text
>> attachment with the display names and email addresses. You can also save
>> as
>> text or rtf file. They'll be in column format - you'll need to work them
>> in
>> word or Excel to remove the display names and comma delimit the
>> addresses.
>>
>> If that is not an option in your version - these are other methods:
>> if you received a copy of a message to the DL, check the header and with
>> some effort cleaning it up, you could get the addresses from the internet
>> header.
>>
>> Print to an electronic format and OCR it. If you use Acrobat, print to it
>> and copy the addresses using the text tool. You'll need to clean the
>> file
>> up to remove the display names. (The fastest way seems to be to crop it
>> so
>> just the addresses are in the file then OCR or whatever.)
>>
>>
>>
>> --
>> Diane Poremsky [MVP - Outlook]
>> Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
>> Outlook 2007: http://www.slipstick.com/outlook/ol2007/
>>
>> Outlook Tips by email:
>> dailytips-subscribe-request@lists.outlooktips.net
>>
>> EMO - a weekly newsletter about Outlook and Exchange:
>> EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH.EASE.LSOFT.COM
>>
>> Outlook Tips: http://www.outlook-tips.net/
>> Outlook & Exchange Solutions Center: http://www.slipstick.com
>>
>> You can access this newsgroup by visiting
>> http://www.microsoft.com/office/community/en-us/default.mspx or point
>> your
>> newsreader to msnews.microsoft.com.
>>
>>
>> "Vorv" <Vorv@discussions.microsoft.com> wrote in message
>> news:CF0FF44E-5CEA-4AD3-B26D-4E143706A901@microsoft.com...
>> > I have a distribution list that displays the aliases - I want to pull
>> > just
>> > the email address so that I end up with (example):
>> >
>> > joe@ms.com,jane@ms.com,trudy@ms.com,james@ms.com
>> >
>> >
>> > Is this possible?
>> >
>>

Re: Extract delimted list of email addresses from a distribution l by Vorv

Vorv
Thu Jul 31 06:40:01 PDT 2008

Thanks for your reply Michael:

Maybe I'm going about this wrong: I have opened a new message, put in the
DL, and then expanded it, showing the aliases of all memebers. When I save
it as text, I get a text file of all the aliases, not the actual email
addresses, which is what I need.

PV

"Michael Bauer [MVP - Outlook]" wrote:

>
>
> You can save the item as a txt file, and open that in Excel, then it's easy
> to delete everything you don't need, and save the item again.
>
> --
> Best regards
> Michael Bauer - MVP Outlook
>
> : VBOffice Reporter for Data Analysis & Reporting
> : Outlook Categories? Category Manager Is Your Tool
> : <http://www.vboffice.net/product.html?pub=6&lang=en>
>
>
> Am Tue, 29 Jul 2008 11:22:34 -0700 schrieb Vorv:
>
> > I have a distribution list that displays the aliases - I want to pull just
> > the email address so that I end up with (example):
> >
> > joe@ms.com,jane@ms.com,trudy@ms.com,james@ms.com
> >
> >
> > Is this possible?
>

Re: Extract delimted list of email addresses from a distribution l by Vorv

Vorv
Thu Jul 31 06:48:02 PDT 2008

Hi Diane:

I've got all the way to the send > internet format. When I open the .txt
attachment, it only has the name of the DL, with no member info. How are you
opening the form? Any further insight would be appreciated.

PV

"Diane Poremsky [MVP]" wrote:

> Open the DL form. Under the office icon is the save and close button, Send
> button with dropdown, and Delete. Click the Send button and choose internet
> format. This creates a new message with a text attachment. Open the
> attachment and close the new message. you'll need to work the text to make
> it delimited, there is no way around that.
>
> --
> Diane Poremsky [MVP - Outlook]
> Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
> Outlook 2007: http://www.slipstick.com/outlook/ol2007/
>
> Outlook Tips by email:
> dailytips-subscribe-request@lists.outlooktips.net
>
> EMO - a weekly newsletter about Outlook and Exchange:
> EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH.EASE.LSOFT.COM
>
> Outlook Tips: http://www.outlook-tips.net/
> Outlook & Exchange Solutions Center: http://www.slipstick.com
>
> You can access this newsgroup by visiting
> http://www.microsoft.com/office/community/en-us/default.mspx or point your
> newsreader to msnews.microsoft.com.
>
>
> "Vorv" <Vorv@discussions.microsoft.com> wrote in message
> news:99B769DE-19F7-406F-A4BF-1E96BE7176EA@microsoft.com...
> > Thanks Diane.
> >
> > I use 2007, but can't find the "send in internet format" option.
> >
> > I have done the following:
> >
> > opened a new email, typed in the DL and expanded it to show all the
> > aliases.
> > Chose "save as" text, but the file just gave me the aliases in plain text.
> > No email addresses.
> >
> > I feel like I'm almost there... any other insight would be appreciated!
> >
> > PV
> >
> > "Diane Poremsky [MVP]" wrote:
> >
> >> Not sure if this works in other versions - but in Outlook 2007, open the
> >> DL
> >> and choose Send... in internet format. The new message will have a text
> >> attachment with the display names and email addresses. You can also save
> >> as
> >> text or rtf file. They'll be in column format - you'll need to work them
> >> in
> >> word or Excel to remove the display names and comma delimit the
> >> addresses.
> >>
> >> If that is not an option in your version - these are other methods:
> >> if you received a copy of a message to the DL, check the header and with
> >> some effort cleaning it up, you could get the addresses from the internet
> >> header.
> >>
> >> Print to an electronic format and OCR it. If you use Acrobat, print to it
> >> and copy the addresses using the text tool. You'll need to clean the
> >> file
> >> up to remove the display names. (The fastest way seems to be to crop it
> >> so
> >> just the addresses are in the file then OCR or whatever.)
> >>
> >>
> >>
> >> --
> >> Diane Poremsky [MVP - Outlook]
> >> Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
> >> Outlook 2007: http://www.slipstick.com/outlook/ol2007/
> >>
> >> Outlook Tips by email:
> >> dailytips-subscribe-request@lists.outlooktips.net
> >>
> >> EMO - a weekly newsletter about Outlook and Exchange:
> >> EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH.EASE.LSOFT.COM
> >>
> >> Outlook Tips: http://www.outlook-tips.net/
> >> Outlook & Exchange Solutions Center: http://www.slipstick.com
> >>
> >> You can access this newsgroup by visiting
> >> http://www.microsoft.com/office/community/en-us/default.mspx or point
> >> your
> >> newsreader to msnews.microsoft.com.
> >>
> >>
> >> "Vorv" <Vorv@discussions.microsoft.com> wrote in message
> >> news:CF0FF44E-5CEA-4AD3-B26D-4E143706A901@microsoft.com...
> >> > I have a distribution list that displays the aliases - I want to pull
> >> > just
> >> > the email address so that I end up with (example):
> >> >
> >> > joe@ms.com,jane@ms.com,trudy@ms.com,james@ms.com
> >> >
> >> >
> >> > Is this possible?
> >> >
> >>
>

Re: Extract delimted list of email addresses from a distribution l by Diane

Diane
Thu Jul 31 15:13:57 PDT 2008

See http://www.slipstick.com/Tutorials/dl/dl.asp

You can also use file, save as, but I like this method because I don't have
to go looking for the file.

--
Diane Poremsky [MVP - Outlook]
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:
dailytips-subscribe-request@lists.outlooktips.net

EMO - a weekly newsletter about Outlook and Exchange:
EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH.EASE.LSOFT.COM

Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com

You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point your
newsreader to msnews.microsoft.com.


"Vorv" <Vorv@discussions.microsoft.com> wrote in message
news:B68565AF-AB97-4BE9-84D3-1CBA79B6152C@microsoft.com...
> Hi Diane:
>
> I've got all the way to the send > internet format. When I open the .txt
> attachment, it only has the name of the DL, with no member info. How are
> you
> opening the form? Any further insight would be appreciated.
>
> PV
>
> "Diane Poremsky [MVP]" wrote:
>
>> Open the DL form. Under the office icon is the save and close button,
>> Send
>> button with dropdown, and Delete. Click the Send button and choose
>> internet
>> format. This creates a new message with a text attachment. Open the
>> attachment and close the new message. you'll need to work the text to
>> make
>> it delimited, there is no way around that.
>>
>> --
>> Diane Poremsky [MVP - Outlook]
>> Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
>> Outlook 2007: http://www.slipstick.com/outlook/ol2007/
>>
>> Outlook Tips by email:
>> dailytips-subscribe-request@lists.outlooktips.net
>>
>> EMO - a weekly newsletter about Outlook and Exchange:
>> EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH.EASE.LSOFT.COM
>>
>> Outlook Tips: http://www.outlook-tips.net/
>> Outlook & Exchange Solutions Center: http://www.slipstick.com
>>
>> You can access this newsgroup by visiting
>> http://www.microsoft.com/office/community/en-us/default.mspx or point
>> your
>> newsreader to msnews.microsoft.com.
>>
>>
>> "Vorv" <Vorv@discussions.microsoft.com> wrote in message
>> news:99B769DE-19F7-406F-A4BF-1E96BE7176EA@microsoft.com...
>> > Thanks Diane.
>> >
>> > I use 2007, but can't find the "send in internet format" option.
>> >
>> > I have done the following:
>> >
>> > opened a new email, typed in the DL and expanded it to show all the
>> > aliases.
>> > Chose "save as" text, but the file just gave me the aliases in plain
>> > text.
>> > No email addresses.
>> >
>> > I feel like I'm almost there... any other insight would be appreciated!
>> >
>> > PV
>> >
>> > "Diane Poremsky [MVP]" wrote:
>> >
>> >> Not sure if this works in other versions - but in Outlook 2007, open
>> >> the
>> >> DL
>> >> and choose Send... in internet format. The new message will have a
>> >> text
>> >> attachment with the display names and email addresses. You can also
>> >> save
>> >> as
>> >> text or rtf file. They'll be in column format - you'll need to work
>> >> them
>> >> in
>> >> word or Excel to remove the display names and comma delimit the
>> >> addresses.
>> >>
>> >> If that is not an option in your version - these are other methods:
>> >> if you received a copy of a message to the DL, check the header and
>> >> with
>> >> some effort cleaning it up, you could get the addresses from the
>> >> internet
>> >> header.
>> >>
>> >> Print to an electronic format and OCR it. If you use Acrobat, print to
>> >> it
>> >> and copy the addresses using the text tool. You'll need to clean the
>> >> file
>> >> up to remove the display names. (The fastest way seems to be to crop
>> >> it
>> >> so
>> >> just the addresses are in the file then OCR or whatever.)
>> >>
>> >>
>> >>
>> >> --
>> >> Diane Poremsky [MVP - Outlook]
>> >> Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
>> >> Outlook 2007: http://www.slipstick.com/outlook/ol2007/
>> >>
>> >> Outlook Tips by email:
>> >> dailytips-subscribe-request@lists.outlooktips.net
>> >>
>> >> EMO - a weekly newsletter about Outlook and Exchange:
>> >> EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH.EASE.LSOFT.COM
>> >>
>> >> Outlook Tips: http://www.outlook-tips.net/
>> >> Outlook & Exchange Solutions Center: http://www.slipstick.com
>> >>
>> >> You can access this newsgroup by visiting
>> >> http://www.microsoft.com/office/community/en-us/default.mspx or point
>> >> your
>> >> newsreader to msnews.microsoft.com.
>> >>
>> >>
>> >> "Vorv" <Vorv@discussions.microsoft.com> wrote in message
>> >> news:CF0FF44E-5CEA-4AD3-B26D-4E143706A901@microsoft.com...
>> >> > I have a distribution list that displays the aliases - I want to
>> >> > pull
>> >> > just
>> >> > the email address so that I end up with (example):
>> >> >
>> >> > joe@ms.com,jane@ms.com,trudy@ms.com,james@ms.com
>> >> >
>> >> >
>> >> > Is this possible?
>> >> >
>> >>
>>