Re: Extract delimted list of email addresses from a distribution l
  Home FAQ Contact Sign in
microsoft.public.outlook.contacts only
 
Advanced search
POPULAR GROUPS

more...

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

Group: microsoft.public.outlook.contacts · Group Profile
Author: Diane Poremsky [MVP]
Date: Jul 31, 2008 15:13

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" 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" 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" 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?
>>>>>
>>>>
>>
no comments
diggit! del.icio.us! reddit!