PSFS Offering or IQ - Export: How to convert email addresses listed in Excel to an Outlook email list

How to convert email addresses listed in Excel to an Outlook email list

This article deals with converting an Excel email address list created in the contribution statements process or through IQ to an Outlook email list.

  • If you want to create a list of all family emails to copy into your email address bar via the PSFS Family Directory, please see this article.

The Givers tab of the contribution statement report offers an option to export a list of giver emails.screenshot.png

This list can't just be copied and pasted into Outlook, so the following instructions will show how to format it in a way where the email addresses can be copied and pasted into Outlook.  

  • Note: This same process may be used when using IQ to create a query resulting in a list of email addresses. 
  1. Copy (Ctrl-c) and paste (Ctrl-v) the column of email addresses from the Excel file into a blank MS Word document.
  2. After pasting them into a blank Word document, a 'Paste Options' menu displays. Click the Keep Text Only option.
    Paste_text_only.png
  3. In the upper right-hand corner of Word's Home tab (the default tab), click the Replace button. This opens the Find and Replace dialog box.
  4. Inside the Find and Replace dialog box, enter the following:

    Find what: ^p  (press shift  and 6)
    Replace with: ; (semicolon)


    replace_carrot_p_with_semicolon.png

  5. Click the "Replace All" button.
    • A window will open stating "All done. We made X# replacement(s)."
    • Click OK.
  6. Close the Find and Replace dialog box.
  7. Copy (Ctrl-c) the resulting formatted list of email addresses separated only by semicolons (no spaces) and paste (Ctrl-v) it into the address field of your Outlook email message.

 

 

 

 

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.