[americamba]

I have winXPpro. I use Outlook Express 6. I have a bunch of email messages that went to a specific folder in my oe. Now I need to get the email addresses for these messages. I can't do it manually. There are a lot of them.

How can I get a list or database that would have the email addresses?

thanks , frank

[TheShooter93]

It's been a while since I've used Outlook Express, but here are instructions on how to do it:
http://support.microsoft.com/kb/270670

[americamba]

Ok I followed the MS instructions you indicated. I have all my email folders (from Mom, recipes, jokes, sent etc.) in separate dbx files in the new folder email backup.

Now how do I get to use these dbx files. One of them (the purpose for this effort) has a bunch of email address that got put there automatically by a message rule I made. They were messages from a specific group of people. Now I want them for mailing a bulletin to them.

So I need to turn the dbx into csv or something useful, now what?

thanks, Frank

[throoper]

Hi Frank,

GO HERE to get MailViewer.
Open a DBX file with it and then click Messages>Collect Email Addresses.
They will appear in the bottom pane.
Right click in the bottom pane and click Select all on the menu.
Right click and select copy.
Paste them into Notepad or your text editor of choice.

T.

[americamba]

Thanks , what a handy deal. I have been years with that problem and now it's solved. Sure I could do what the developer probably programmed. But it took so much time and I was too lazy to make a macro. thanks again, Frank

[throoper]

You're welcome.

T.

[americamba]

I spoke too sonn. it works fine, It gets the addresses in the bottom page but TWICE one after the other with no dividing character. I thought i could use "find replace" in a divider(semicolon or camma) after the dot com and separate the the dupes but i have too many .edu, .cn .ru etc so it drives me crazy.

Did I do something wrong using the program?. Test it out for me. See what you get.
\
\thanks, Frank

[throoper]

I see what you mean. You're not doing something wrong.

The Addresses are extracted along with the display name.
mycontact@somewhere.com = my contact
If there's no display name listed, it uses the address in it's place.
mycontact@somewhere.com = <mycontact@somewhere.com>

Hmmm!!! If it's saved as a CSV, the address and display name wind up as one cell.
So that's only going to give you a list that will Import the entire thing as the E-mail address.
Looks like the only advantage would be that it will only extract the address once (if there are multiple e-mails from the same sender) and put them in alphabetical order.

I can't think offhand of a simple way to separate the address from the display name.

[throoper]

When in doubt, ask an underpaid secretary.

This seems really simple.
Save the list as a CSV.
Each row will be a single cell when opened in Excel.
Select the entire list.
Click Data>Text to Columns.
Check Delimited>Next
Check Other and type = in the box>Next
If the preview looks good, click finish.
The data should be split into 2 cells.
Delete the column with the <> around the address.
Import the remaining column into the OE Address book.

I tried it out using a New Identities Address book so the Imported addresses are by themselves rather than merging with my existing Address book.
Then you can export it to whatever format you want (CSV, WAB, etc.)

[EAFiedler]

Reopened per request.

[americamba]

Thanks throoper but the cells still are double in excel

Know any better mail reader program? I have tried Mailview. It gets the emails OK but puts them on one line along with the display name and no delimter between (for example,

247LIBZA@GMAIL.COM247LIBZA@GMAIL.COM =
340227712@QQ.COM340227712@QQ.COM =
568528732@QQ.COM568528732@QQ.COM =
933K@MAIL.RU933K@MAIL.RU =

so I can't use them or clean them up. Any new ideas?

thanks, Frank

[americamba]

I don't see any instructions as to how to convert an outlook express 6 email folder (NOT my address book) to a csv file. any ideas? thanks, Frank

[americamba]

Hey all,

Some one gave me a good idea.

I take the result that I am complaining about (the email and name run together) and runa find and replace operation on it as follows:

I get the idea but i also do not know how to work it.

For example with a page full of lines like the following (results of MailView program - see my post of 03-Sep-2010, 11:58 AM )

247LIBZA@GMAIL.COM247LIBZA@GMAIL.COM
340227712@QQ.COM340227712@QQ.COM
568528732@QQ.COM568528732@QQ.COM

I would like to do a "replace" operation like the following:
Replace @+unknown amount of digits or characters+@ with @

That would strip off "@GMAIL.COM247LIBZA" and leave me with the cleaned up email I need, namely 247LIBZA@gmail.com. A replace operation like this would clean up the whole file of 500 client's emails I have. Thanks for the idea Chandan.

Now how do I run the replace operation in any commonly known program, such as Txt, MSWord, excel or Access?

best wishes, Frank

[throoper]

Open it in Excel.
Edit>Replace.
Find line type @*@ and Replace line type @ then click Replace all.

T.

[americamba]

That sure was easy, thanks throoper. i better learn my excel

bst, frank