Ok this is what i have so far

Editing
admin/orders.php

around line 135 it reads

PHP Code:

            $message 
=
            
EMAIL_TEXT_ORDER_NUMBER ' ' $oID "\n\n" .
            
EMAIL_TEXT_INVOICE_URL ' ' zen_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO'order_id=' $oID'SSL') . "\n\n" .
            
EMAIL_TEXT_DATE_ORDERED ' ' zen_date_long($check_status->fields['date_purchased']) . "\n\n" .
            
strip_tags($notify_comments) .
            
EMAIL_TEXT_STATUS_UPDATED sprintf(EMAIL_TEXT_STATUS_LABEL$orders_status_array[$status] ) .
            
EMAIL_TEXT_STATUS_PLEASE_REPLY
I changed it to
PHP Code:

            $message 
=
            
EMAIL_TEXT_ORDER_NUMBER ' ' $oID "\n\n" .
            
EMAIL_TEXT_INVOICE_URL ' ' zen_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO'order_id=' $oID'SSL') . "\n\n" ;
        if (
$orders_status_array[$status] == 'Delivered') {$message .= "If you purchased a downloadable product, please follow the above link to download your purchase. \n\n";} 
            
$message .=
            
EMAIL_TEXT_DATE_ORDERED ' ' zen_date_long($check_status->fields['date_purchased']) . "\n\n" .
            
strip_tags($notify_comments) .
            
EMAIL_TEXT_STATUS_UPDATED sprintf(EMAIL_TEXT_STATUS_LABEL$orders_status_array[$status] ) .
            
EMAIL_TEXT_STATUS_PLEASE_REPLY
When i switch the order status to "delivered" the message is displayed, however it is displayed for all delivered orders, whether they contain downloadable product or not