Lookup field renders incorrectly (ID instead of value) when used in record template

Lookup field renders incorrectly (ID instead of value) when used in record template

I have a custom record template I send using sendmail as an attachment on button click in a report's record. 

Most of the fields show up correctly but one field which in the corresponding form is a lookup to another table shows the IDs instead of values. Any idea how to fix this?  See the last row "Products of Interest".