Share via

Create a email address list from my sent emails folder

Anonymous
2021-03-03T22:24:52+00:00

Is there an easy way to create an excel sheet list of email addresses from the emails that I have already sent? It would be even better if I can pull the first name from the body of the email in a separate column in the excel sheet. I sent about 1000 emails and I now need a list of the email addresses that I sent them to.

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

Answer accepted by question author

  1. Anonymous
    2021-03-04T02:17:11+00:00

    Hi Matt63PA,

    Welcome joining the community.

    According to my research, you can follow below steps to create an email address excel list from your sent emails folder:

    1: Launch Microsoft Outlook desktop app. Click on File > Open & Export.

    2: Select Import/Export option.

    3: Select Export to a file option > Next.

    4: Select Comma Separated Values >Next

    5: select Sent Items folder> Next.

    6: select the file saving location using the Browse button; click Next.

    7: Checkmark Export “sent items” from folder and click Finish.

    8: Open the CVS file, you can find the recipient’s email addresses in “To: Name” area.

    Hope above information helps.

    Regards,

    Grace

    10 people found this answer helpful.
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2021-03-08T15:08:10+00:00

    Hi Grace!

    I think this will get me what I need! I appreciate your help!

    0 comments
  2. Anonymous
    2021-03-06T04:41:48+00:00

    Hi Matt63PA,

    Have you tried above method?

    Regards,

    Grace

    0 comments