Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I want to export all contacts in outlook 2007 for import to gmail. Many of the contacts are members of various distribution lists, but there are no info in the exported csv-file as to which distribution list they belong. Is this possible somehow?

share|improve this question
up vote 0 down vote accepted

The "Import and Export" dialog doesn't do so, but the method described here looks like it should do the job well enough, if you don't mind it taking a reasonable amount of effort for each list you export.

share|improve this answer
Problem is not every contact is part of a list. Seems only way in this case is to then match exported lists against total contacts (800) which seems tedious. – Bo01 Dec 19 '12 at 20:58
Done some more research and it seems these distribution lists does not have any connection "backwards" at all to contacts. So you'll have to export contacts and the lists to csv and txt files. Then match them in xls. – Bo01 Dec 19 '12 at 23:37
Yup. Trust Outlook not to make anything simple. – Aaron Miller Dec 20 '12 at 13:37
Yeah, left Outlook 5 years ago. Coming back occasionally is like .. – Bo01 Dec 20 '12 at 16:28
Sure is. Me, I spent some time a few years ago learning how to VBScript and MAPI so that I could make Outlook less stupid, but since then I've switched everything over to Thunderbird and haven't looked back. Glad to be of help! – Aaron Miller Dec 20 '12 at 16:43

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .