Extract delimted list of email addresses from a distribution list?

  • Thread starter Thread starter Vorv
  • Start date Start date
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/



EMO - a weekly newsletter about Outlook and Exchange:
(e-mail address removed)




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.
 
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 said:
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/



EMO - a weekly newsletter about Outlook and Exchange:
(e-mail address removed)




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 said:
I have a distribution list that displays the aliases - I want to pull just
the email address so that I end up with (example):

(e-mail address removed),[email protected],[email protected],[email protected]


Is this possible?
Click to expand...
Click to expand...
 
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:
 
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/



EMO - a weekly newsletter about Outlook and Exchange:
(e-mail address removed)




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 said:
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 said:
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/



EMO - a weekly newsletter about Outlook and Exchange:
(e-mail address removed)




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 said:
I have a distribution list that displays the aliases - I want to pull
just
the email address so that I end up with (example):

(e-mail address removed),[email protected],[email protected],[email protected]


Is this possible?
Click to expand...
Click to expand...
Click to expand...
 
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
 
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 said:
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/



EMO - a weekly newsletter about Outlook and Exchange:
(e-mail address removed)




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 said:
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 said:
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/



EMO - a weekly newsletter about Outlook and Exchange:
(e-mail address removed)




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.


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

(e-mail address removed),[email protected],[email protected],[email protected]


Is this possible?
Click to expand...
Click to expand...
Click to expand...
 
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/



EMO - a weekly newsletter about Outlook and Exchange:
(e-mail address removed)




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 said:
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 said:
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/



EMO - a weekly newsletter about Outlook and Exchange:
(e-mail address removed)




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 said:
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

:

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/



EMO - a weekly newsletter about Outlook and Exchange:
(e-mail address removed)




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.


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

(e-mail address removed),[email protected],[email protected],[email protected]


Is this possible?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top