Additional fields needed in Notification Emails

[Kaos77]

Ok, I've googled, wiki'd and searched Sugarforums and have found only bits of what I need to accomplish this.

I need to add additional fields to notification emails. For example, I want to add Account name and contacts/phone numbers to a Case assignment email.

I know the files that need edited, I just don't know how to tell the files to search a different table for the data to look for.

Once I get the proper code in /modules/Cases/Cases.php it should be as simple as bringing over the variable into /include/language en_us.notification_template.html, correct? The problem I am having is how to get the variable in Cases.php to grab the correct field from whatever table I am getting my data from.

Any pointers or tutorials someone could point me to would be great!

Running Sugar 5.1c with Mysql 5.0.62 and PHP 5.2.6

[eggsurplus]

If you can edit the email body you should be able to insert new fields with a combination of: $+beanname+_+fieldname. For example, for contacts you could add the last name by inserting: $contact_last_name.

Example:

 Hello $contact_first_name,
 
Your case....