How do I find people who do not have an Email address?

Look here for commonly asked questions about how to use the software.

How do I find people who do not have an Email address?

Postby Technical Support on Wed Feb 21, 2007 1:38 pm

Question: How can I get a list of people who do not have an email address?

1. Go to Reports & Mailings
2. Select Mailing List - Pre-Defined
3. Select the group you are looking for in the list displayed in the middle of the screen.
4. Households or Individuals - Select “Output A Record for Every Person”
5. Select Excel Spreadsheet in the Output box
6. Click Create Excel File

Now that you have your Excel spreadsheet:
1. Highlight all your data
2. Click Data
3. Click Sort
4. Sort by email address ( and any additional fields you might want to sort by)
5. Click OK

The people without email addresses will be sorted to the top.

You can delete all the rows of people who do have an email address. This spreadsheet can then be used as the data source for a Word mail merge. In Word, click on Tools, Letters and Mailings, Mail Merge and follow the wizard.

Date Created 02/21/2007
Technical Support
People Driven Software
866-PDS-WARE (737-9273)
Technical Support
Posts: 100
Joined: Fri Oct 01, 2004 10:37 am

Return to Express - Frequently Asked Support Questions