View Full Version : How to convert a .wab-file into excel
mistergere
Jul 3, 2008, 07:09 AM
I have the following problem:
I have my contacts in groups in my outlook express contact list. I need this contacts, sorted by groups in cvs or excel. If I import them to e.g. Outlook I get the contacts, but not sorted in groups. I can save the groups as a .wab-file, but do I get them into excel?
ScottGem
Jul 3, 2008, 07:16 AM
Can you export as a csv or txt file?
mistergere
Jul 3, 2008, 08:34 AM
No I can't
JBeaucaire
Jul 3, 2008, 09:11 AM
no i can't
Are you sure? I haven't used OE in awhile, but I used to do that very thing.
To export the address book:
Open Outlook Express
Select FILE > EXPORT > ADDRESS BOOK
Select Text File (Comma Separated Values)
Click EXPORT
Type a file name in the "Save exported file as" input box
For example type, "C:\MYADRBOK.CSV"
Click NEXT
Optionally select the fields you wish to export and/or click FINISH
Click CLOSE once the exporting is completed
The .CSV file will import into Excel nicely.
mistergere
Jul 3, 2008, 09:28 AM
I can export the address book, for sure, but my groups get lost. That's my problem, you know? I have all addresses in the csv-file, but not separated in the groups.
JBeaucaire
Jul 3, 2008, 09:40 AM
Ah, well, there's the thing. The groups are an internal feature to Outlook.
Why Excel? What's the goal here? I don't know of any eport methodology that converts that info, only the basic contact info.
mistergere
Jul 3, 2008, 09:44 AM
I have a new programm for email marketing and I have to bring the contact details (in groups) from outlook express in a csv-file
ScottGem
Jul 3, 2008, 09:44 AM
How many contacts and how many groups? (I thought you could export to CSV) If its not too many you can easily assign groups in excel.
JBeaucaire
Jul 3, 2008, 09:48 AM
Hehe, I bet it's a huge list.
mistergere
Jul 3, 2008, 10:42 AM
It's a huge list, yes...