DFS Family Directory - Email list: How to create a list of email addresses to use outside of ParishSOFT

How to create a list of email addresses to use outside of ParishSOFT

  1. Filter for the desired Membership Status and Family Group in the list.
  2. Create a spreadsheet from Family Directory using the Excel Button; click on "Create A CSV."
    Family_Directory_Excel_Button.png

 

  1. Once the spreadsheet is produced "Sort & Filter" by the Email Column so that it will push all of the blank entries to the top. 
    Excel_Sort_and_Filter.png 
  1. Copy that Column to the Clipboard.
  2. Go to the website https://delim.co/
  3. Paste the column in the left-hand box and delete all of the rows that are blank, including the header "Family Address."
  4. Click on the gray box with the ","  (see image below)
  5. Click on the blue directional arrow.  (see image below)
  6. Select that new delimited row, copy and paste it into Outlook (Or another email provider) BCC Field. (Click into the field and use Ctrl-a to select all the rows. Then, click Ctrl-c to copy the selection. To paste into outlook, you may use Ctrl-v.)delim.co.png

 

 

 

 

Top

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.