There are a couple different methods that we can use to create our split list queries, but first you will need to set up the main mailing list query that is going to be split for your mailing. If you are looking to mail to all constituents in your database that have not been marked with a Mailing Status field, then you can access this knowledge base article to create a Clean Mailing List: BB740272

In the first method you will split these queries based on Account Numbers. This method is beneficial because it allows for creation of a more even split. Here are the steps for the query on Group A of the split mailing list:
  1. Click Queries
  2. Click on a category that you want to store this query in
  3. Click New Query under the tasks menu
  4. Name the query Group A
  5. Set the Starting criteria to Your Category/Your Complete Mailing List Query
  6. Set the Data Return Type to Accounts
  7. Under MATCH select All
  8. Choose Account from the Available Fields drop down menu and click on Account Number
  9. Fill in Less Than or Equal To 1000 (This value will differ depending on the number of accounts in your database and should be adjusted accordingly to get an even split of lists)
  10. Click Save and Preview

Here are the steps for the query on Group B of the split mailing list:
  1. Click Queries
  2. Click on a category that you want to store this query in
  3. Click New Query under the tasks menu
  4. Name the query Group B
  5. Set the Starting criteria to Your Category/Your Complete Mailing List Query
  6. Set the Data Return Type to Accounts
  7. Under MATCH select All
  8. Choose Commonly Used Fields from the Available Fields drop down menu and click on Individual Transaction Received
  9. Fill in Greater Than 1000 (This field will differ as well depending on what is selected in your Group A query)
  10. Click Save and Preview

The second method would involve using common first names as criteria to create a list of accounts with those specific names, then creating a compound query for the second group. Here are the steps for the query on Group A of the split mailing list:
  1. Click Queries
  2. Click on a category that you want to store this query in
  3. Click New Query under the tasks menu
  4. Name the query
  5. Set the Starting criteria to Your Category/ Your Mailing List Query
  6. Set the Data Return Type to Accounts
  7. Under MATCH select All
  8. Choose Account from the Available Fields drop down menu and click on Name
  9. Fill in a common first name, such as John or Mary, and then click the Plus sign next to the text box to add additional names. Continue this until you have selected the desired number of names. Make sure to keep one name per text box.
  10. Click Save and Preview

Here are the steps for the query on Group B of the split mailing list:
  1. Click Queries
  2. Click on a category that you want to store this query in
  3. Click New Compound Query under the tasks menu
  4. Name the query
  5. Set the Data Return Type to Accounts
  6. Under Combine the Queries select the Subtract icon
  7. For Query 1 choose Your Mailing List Query
  8. For Query 2 choose Group A
  9. Click Save