Programable Email & Displaying Associated Deals

Hi, 

(Not a developer, but tasked to develop)

I’m trying to create a programble email module that displays all the associated deals to the recipient that meet a few filter criteria. It doesn’t need to look super nice, but all I need is a table that shows the deal claim number in one column and a hyperlink to a form with some of the fields dyncamically filled in the other column. 

This is what I have so far, but nothing is rendering in the email tests I send myself. The fallback message is not even displaying. Hoping someone can please tell me what is wrong/missing, or if this can’t work in email.

In the design manager I’m seeing this warning: 
Warning: 9:1 DEAL objects can only be retrieved on membership or password-restricted pages

I asked support about this and they ensured it should work in email and my code is the issue.

{% set deal_ids = crm_associations(contact.hs_object_id, “HUBSPOT_DEFINED”, 4) %}

{% set matching_deals = [] %}
{% set cutoff_date = 1745020800000 %} {# 2025-04-19 in ms since epoch #}

{% for deal_id in deal_ids %}
{% set deal = crm_object(“deal”, deal_id,
“dealname,hubspot_auto_msa_trigger,referral_date,status,dyn365_opportunity_id,claim_number”)
%}

{# Ensure referral_date exists and is BEFORE cutoff #}
{% if deal.hubspot_auto_msa_trigger == “Auto-MSA Start”
and deal.status == “Open”
and deal.referral_date and deal.referral_date|int < cutoff_date %}
{% do matching_deals.append(deal) %}
{% endif %}

{% if matching_deals|length >= 10 %}
{% break %}
{% endif %}
{% endfor %}

{% if matching_deals|length > 0 %}

{% for deal in matching_deals %}

{% endfor %}

Deal Name	Case Update Link
{{ deal.dealname }}	<a href="https://hubspotformplaceholder.com/case-update/?id={{ deal.dyn365_opportunity_id }}&claim_number={{ deal.claim_number }}” target=”_blank”> Update Case

{% else %}

No matching deals found.

{% endif %}