Custom Recipient List

Use this option to create a custom recipient list based on certain conditions; this creates a subset group of your contacts who have something in common;

This could be as simple as wishing to only address the women in the club, for some special event that is "ladies only", or as complex as contacting all men, between 18-50 (search by date of birth), whose last name starts with letters A-M to inform them of their role in a "bring your own" event, and a separate group for those whose last name begins with letters N-Z for slightly different information. As long as the information is accurately entered in your members' database, you can search and create an accurate email addressing only the people you want to address.

If you have the Query for your purposes already saved, choose the Category that it is filed under, select it from the existing Custom Query list, then click on "Generate Email List". 

You will be asked to Confirm Recipient List and Verify Email, click on this button. You will have the opportunity to review the email you are sending and make any small edits that need to be completed before sending.

Note: When using a custom query, you have the ability to schedule your email for a later date. See Buz Mail > List Emails > Send/Schedule > Verify and Send Email for more information.

New Custom Query

If none of your previously created Custom Queries match the group you would like to address, or you are unsure of what Custom Queries you already have saved, click the radio button for "Create New Custom Query" and press "Add New Query", this will bring you to the Query Builder.

Show Existing Queries

If you wish to view all Queries that you have saved, choose "Show Existing Queries" from the  tools available at the top of the menu that will appear. The following menu will open over your page: 

Note: It is highly recommended to save your Queries under a name that is easily identifiable. Example: The Query is searching for men, with first names beginning with either b or c- list the Query as "Males First Name c,d", or something else that you will easily recall. 

Within this menu you have the ability to Test, Copy, Delete and Export this Query:

Test

Selecting "Test" from the Action Menu will display the current results of that query by searching your contact database for all members who fit the description created in the query. Below is an example using the results of a search for all males whose first names begin with either c or d:

Copy

Selecting "Copy" from the Action list will copy the Query, and open it in the same format as you would use for creating a new Query. This is useful if you would like to create a similar Query with a slight alteration. For example: if you would like to change the search for all females with a first name beginning with c,d instead of all males with that requirement.

Delete

Selecting "Delete" from the Action list will bring up a pop-up confirming whether you wish to delete this Query or not. If you do wish to delete it, click on yes, if you don't, click on cancel to return to the previous menu without making any changes.

Export

Selecting "Export" from the Action list will initiate the download of an Excel sheet with the results of this Query onto your computer. This will allow you to view the entire list in an editable format, as well as being able to email the list to others within your company, if the information is needed elsewhere, or to create an email subgroup that can be uploaded for use as an "Uploaded Recipient List", which will be discussed in another section. 

For more information on Uploaded Recipient Lists, either click on the link or see Buz Mail > List Emails > Send/Schedule > Uploaded Recipient List in the Reference Guide.

If the list of existing Queries does not contain what you need, click the "x" button at the top of the menu to return to the "Custom Query Builder" menu.

Custom Query Builder

This tool will allow you to create and save a new Query, allowing you to use it again in the future.

New Query:

Category- For filing purposes, it is necessary to choose, or add, a "Category" to save this New Query under. This will enable you to find this specific query easier. The Category Title can be as simple as the title of the event you were sending out emails for, under which there may be numerous saved Queries; or it may be something more broad, such as a Category specifically for Alphabetical searches etc. 

If the Category that you need is not yet created, click on "Add Category". A simple window will appear with the space to enter the name of a new Category and either save the Category name, or if you have changed your mind about creating a new Category you are able to cancel and return to the previous window.

Make sure that you file your Queries in a way that is intuitive and useful for you.

Query Name- The Query name should be something easily identifiable; try to somehow incorporate what the search is either for, or consists of, so as to facilitate future searches for the same or similar results.

Note: Saving a Query only saves the parameters for the search, it does not save the results. Therefore, any Query that is used again in the future will re-search your database for the current information stored. This allows all searches done to only include up-to-date information, ensuring that you are not emailing people who are no longer members, and that you are including new members who have joined since the Query was created. If you wish to keep the results, export them onto your computer as an Excel sheet.

Condition Field Selection:

There are three options for the type of Conditions to use: Personal, Contact and Business. Select whichever of these allows you to search the information necessary for the subset you are seeking, and press "Display Condition Editor". The following editor will appear:

Now for a more in depth explanation of how to fill in each of the fields, based on the chosen "Condition Field Selection" heading:

Personal- This provides you the option to search the following information under "Field Name":

Contact- This provides you the option to search the following information under "Field Name":

Business- This provides you the option to search the following information under "Field Name":

Note: Depending on how general or specific you make your Query, a list of all members in your database will be returned who fulfill the parameters of the search. This is great for grouping based on commonalities (eg: from the same company, with the same job title, from the same state/province, etc.). There may be searches which will only return one member.

If you have chosen the wrong "Condition" field and wish to re-access the Condition Field Selection menu, simply click the "Reset" button at the top of the "Custom Query Builder" menu.

Also, if you decide you no longer want to create a Custom Query, but would prefer to use one of the pre-set options under "Built-in Recipient List", click the "Back" Button at the top of the "Custom Query Builder" menu.

Once your Query has been fully defined, click on "Test Query" to see the results of the search. If the results meet your needs, click on "Save Query". This will return you to the "Select the type of recipient list" menu. Click on "Generate Email List". 

Note: to save the Query you will need to have chosen a category and name for it first.

You will be taken to the below menu:

The screen shows you how many people will be sent the email. Click on "Confirm Recipient List and Verify Email" to go to the final step of sending the email.

Recall that with this option you will have the choice to either Send the email, or to schedule. See Buz Mail > List Emails > Send/Schedule > Verify and Send Email in the Reference Guide for further details on this option.