How to display lead email address in email notification

**marcuscherry** · 2008-12-02, 06:11 PM

Hi,

I have modified my email notification template to include office phone number and lead source description, but I want to add an email address and custom fields to the notification email as well.

It seems that the email field is not part of the leads table.

What modifications do I need to make to get this to work?

this is the code I am using in lead.php

Code:

function set_notification_body($xtpl, $lead, $leads_cstm)
	{
		global $app_list_strings;
        global $locale;

		$xtpl->assign("LEAD_NAME", $locale->getLocaleFormattedName($lead->first_name, $lead->last_name, $lead->salutation));
		$xtpl->assign("LEAD_SOURCE", (isset($lead->lead_source) ? $app_list_strings['lead_source_dom'][$lead->lead_source] : ""));
		$xtpl->assign("LEAD_STATUS", (isset($lead->status)? $app_list_strings['lead_status_dom'][$lead->status]:""));
		$xtpl->assign("LEAD_DESCRIPTION", $lead->description);
		$xtpl->assign("LEAD_SOURCE_DESCRIPTION", $lead->lead_source_description);
		$xtpl->assign("LEAD_OFFICE_PHONE", $lead->phone_work);
		$xtpl->assign("LEAD_EMAIL", $lead->email1);

		return $xtpl;
	}

This is the code I have in en_us_notify_template.html

Code:

<!-- BEGIN: Lead -->
{ASSIGNER} has assigned a Lead to {ASSIGNED_USER}.

Name: {LEAD_NAME}
Phone: {LEAD_OFFICE_PHONE}
Email: {LEAD_EMAIL}
Lead Source Description: {LEAD_SOURCE_DESCRIPTION}
Status: {LEAD_STATUS}
Lead Type: {LEAD_TYPE}
Comments: {LEAD_DESCRIPTION}

You may review this Lead at:
<{URL}>
<!-- END: Lead -->

Thanks

Marcus