View Single Post
  #5  
Old July 30th 08, 03:06 AM posted to microsoft.public.outlook.contacts
Diane Poremsky [MVP]
external usenet poster
 
Posts: 12,991
Default Extract delimted list of email addresses from a distribution l

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:


EMO - a weekly newsletter about Outlook and Exchange:


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/comm...s/default.mspx or point your
newsreader to msnews.microsoft.com.


"Vorv" wrote in message
...
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:


EMO - a weekly newsletter about Outlook and Exchange:


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/comm...s/default.mspx or point
your
newsreader to msnews.microsoft.com.


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




Is this possible?


Ads