Share via

How do I convert my MS Outlook contacts list to Excel files for bulk editing and condensing to make a mailing list with full data?

Anonymous
2023-01-24T04:15:58+00:00

I have about 500 contacts on my MS Outlook contacts list, but I want to edit this down to initiate a charity mailing, including filling in additional address info for some which are currently just email addresses. I think this editing would be easier if I could convert all my contacts to Excel files, then delete or add information to enable a (Post Office) mailing to reach the edited list of contacts. How can I make these edits most easily, perhaps beginning by converting all my contacts to Excel files?

Outlook | Windows | Classic Outlook for Windows | For home

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-01-24T06:22:21+00:00

    Dear Lee Kenna,

    Good day!

    Thank you for posting to Microsoft Community. I am glad to assist you.

    As per the description you have shared, I understand that you want to convert your Outlook contact list to Excel file.

    To convert your Outlook contact list to Excel file for bulk editing, you can export your contact list as CSV file from Outlook and open using your Excel. To do this, please kindly follow these steps: Go to File -->Open & Export -->Import/Export --> Export to a file -->Comma Separated Values --> select and expand your account, then choose Contacts --> select Browse to choose a place you want to save your CSV file -->if you want to customize your field in your contact select Map Custom Fields, Otherwise select Finish. you can refer to the below screenshot:

    Note: It may take some time to complete the exporting contact process, if your contact list size is big.

    After the process completed, go to your saved file location (a place previously you choose to save) --> open and edit your contacts.

    You can refer to my test result.

    I look forward to you update. I hope the above information will be helpful. Please feel free to let me know if there are any questions or if I've got you wrong. I will keep assisting you based on the information you provide. I sincerely appreciate your patience and cooperation.

    Thanks for your precious time.

    Have a nice day! 

    Sincerely,
    Libeamlak | Microsoft Community Moderator

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2023-01-26T06:35:58+00:00

    Dear Lee Kenna,

    Good day!

    I am glad that your issue is resolved. I will surely raise your suggestion to our Product Development Team and hopefully this can be included in the future updates. In meantime, you can submit your suggestion as an idea on our feedback site Outlook · Community (microsoft.com). At the same time, if above reply could clarify your issue, could you please help to vote my previous reply or submit feedback in order to help more others who get similar issue and searching for the same solution.

    Thanks so much for your precious time and cooperation. For other questions, feel free to add your post in the Microsoft Community team.

    Stay safe and healthy.

    Have a good day!

    Sincerely,

    Libeamlak | Microsoft Community Moderator

    0 comments
  3. Anonymous
    2023-01-25T18:42:31+00:00

    This did work for my issue! A bit of working, to get the right format converted into Excel, but I did finally get a file to edit down as I need. Thanks very much for valuable directions. I never would have figured this out, and hopefully it may become easier in a future software mod. This did it for me.

    Thanks again,

    Lee

    0 comments