Problem:

The issue here is that the user wanted to pre filter their view so that only specific products will be displayed using that view.
Solution:
If you are using our Block builder then you should be able to see a query filter in the Content selection section under the Block tab.

This query filter section should allow you to create a static filter that is based on any post attribute such as custom fields or taxonomy.

Problem:

Use WP_Query to extract all order posts containing a specific value on the select field.

Solution:

The WP_Query will query posts in "Published" status by default:
https://developer.wordpress.org/reference/classes/wp_query/#status-parameters

But Woocommerce order posts do not use WP default status, so you need to define the post status parameter in WP_Query.

For example:

https://toolset.com/forums/topic/query-select-field/#post-2101145

Relevant Documentation:

http://hookr.io/functions/wc_get_order_statuses/

Problem:

The problem here is that the user wanted to do a custom from Header in their email. This email should come from the form dynamically.

Solution:
You aren't able to do this using the user interface on the backend, however it is possible to modify the email header using the hook below.
https://toolset.com/documentation/programmer-reference/cred-api/#cred_mail_header

Based on the custom field i'm assuming that you're getting the email from the current post that is being created by the form. In this case you should be able to do this.

function customise_cred_notifications( $headers, $formid, $postid, $notification_name, $notification_number ) {
   if ($formid==5 && $notification_name=='some name'){
    $myheaders = array();
    $email = get_post_meta('wpcf-consumeremail', $postid);
    $myheaders = array( 'Reply-To: '.$email);
    return array_merge($headers, $myheaders);
}
      return $headers;
}
add_filter('cred_mail_header', 'customise_cred_notifications', 10, 5);

In this code you will replace the 5 with the ID of your form and 'some name' with the name of the notification that you want to target.