2010 Outlook group dist list

5 pts.
Tags:
Microsoft Outlook 2010
Microsoft Outlook features
I work for a large company with many email group dist lists. I need to copy some of these quite large lists in specific groups with the detail information onto a Word or Excel spreadsheet for visual reference of that particular group with the ability to add notes and additional contact information for each employee. I open the distribution list and can highlight them but Ctrl C does not work. I am hoping there is a simpler way to transfer that data to a spreadsheet without having to re-type.

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • davidcarr
    Here is how someone did it This is how I did it. 1a) In Outlook, right click on the group and "Add to Contacts" 1b) In Outlook, expand the group email list. 2) Expand the group email list. 3) Copy all of the email names in the expanded list (I did this with AD user names) 4) Open your contact in outlook and click on the contact you just created. 5) Delete the Contact under “Name” 6) Click "Select Members" 7) Paste the username you copied 8) Outlook will ask you to clarify some names that it has an issue with. 9) When completed, Outlook will show a nice list of names and email addresses and probably say that there are “too many names to save”. 10) click “Save As” and save as a .txt file. 11) copy the items in the saved txt file, paste as text into excel and it should auto matically format (as the saved txt was saved in tab separated format. 12) from there you should be good.
    225 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following