Varying order confirmation email based on product sku

Question

I'm trying to add a link to the order confirmation IF the order has the word ebook. This is a bundled product so it doesn't bring in the SKU for the product I'm referring to. I don't know this is even possible. All I want to do it show a link if the ebook is in the order. If it's not in the order don't show the link. Here's what I have so far.

{{if order.getEmailCustomerNote()}} 
        <table cellspacing="0" cellpadding="0" class="message-container">
            <tr>
                <td>{{var order.getEmailCustomerNote()}}</td>
            </tr>
        </table>
        {{else}}
       {{depend order.getitem().item == 'ebook'}}
       <table cellspacing="0" cellpadding="0" class="message-container">
        <tr>
        <td>{{var order.getEmailCustomerNote()}}</td>
        </tr>
        <tr>
          <p><h2>THE LINK</h2></p>
        </tr>
        </table>

     {{/depend}}
  {{/if}}

Answer 1

This is not impossible. But this will allow some development skills from you. You have to override order model and add your own method that you will be able to call from email templae. In this method you have to pull all order items and products and check if there is a children with particular sku