I would like it to also send another email to the people CC-ed on this request if possible.
The Purchasers are receiving their emails without any issues, however the CC-ed people are not. Not sure what is wrong with my coding here:
//If staff member sends comments/questions about an existing Request to Create new SKU, there is a CC but no CC1
if ((((input.Comments_Questions_to_Purchaser_Assistant != "") && (input.Request_Type == "Create new SKU")) && (input.Email_to_CC != "")) && (input.Email_to_CC1 == ""))
{
sendmail
(
To : input.Email_to_CC
From : zoho.adminuserid
Subject : "Request # " + input.Request_Number + " - NEW Comments/Questions"
Message : "<div>NEW Comments/Questions : (" + input.Comments_Questions_Date_Time + ") " + input.Comments_Questions_to_Purchaser_Assistant + "</div>\n<div> </div>\n<div>Previous Notes: " + input.Comments_Questions + "</div>\n<div> </div>\n<div> </div>\n<div><strong><u>Request Details</u></strong></div>\n<div> </div>\n<div>Request Type : " + input.Request_Type + "</div>\n<div>Request sent to : " + input.Request_Assigned_To + "</div>\n<div> </div>\n<div>Request Date & Time :" + input.Request_Date_Time + "</div>\n<div>Requested By : " + input.Requested_By1 + "</div>\n<div>Deadline for Response : " + input.Deadline_for_Response + "</div>\n<div>Manufacturer Code : " + input.Manufacturer_Code + "</div>\n<div>Product Name : " + input.Product_Name + "</div>\n<div>Product Description : " + input.Product_Description + "</div>\n<div>Product Weblink : " + input.Product_Weblink + "</div>\n<div>Additional Notes : " + input.Additional_Notes + "</div>\n<div> </div>"
)
}
//If staff member sends comments/questions about an existing Request to Create new SKU , there is a CC1 but no CC
if ((((input.Comments_Questions_to_Purchaser_Assistant != "") && (input.Request_Type == "Create new SKU")) && (input.Email_to_CC == "")) && (input.Email_to_CC1 != ""))
{
sendmail
(
To : input.Email_to_CC1
From : zoho.adminuserid
Subject : "Request # " + input.Request_Number + " - NEW Comments/Questions"
Message : "<div>NEW Comments/Questions : (" + input.Comments_Questions_Date_Time + ") " + input.Comments_Questions_to_Purchaser_Assistant + "</div>\n<div> </div>\n<div>Previous Notes: " + input.Comments_Questions + "</div>\n<div> </div>\n<div> </div>\n<div><strong><u>Request Details</u></strong></div>\n<div> </div>\n<div>Request Type : " + input.Request_Type + "</div>\n<div>Request sent to : " + input.Request_Assigned_To + "</div>\n<div> </div>\n<div>Request Date & Time :" + input.Request_Date_Time + "</div>\n<div>Requested By : " + input.Requested_By1 + "</div>\n<div>Deadline for Response : " + input.Deadline_for_Response + "</div>\n<div>Manufacturer Code : " + input.Manufacturer_Code + "</div>\n<div>Product Name : " + input.Product_Name + "</div>\n<div>Product Description : " + input.Product_Description + "</div>\n<div>Product Weblink : " + input.Product_Weblink + "</div>\n<div>Additional Notes : " + input.Additional_Notes + "</div>\n<div> </div>"
)
}
//If staff member sends comments/questions about an existing Request to Create new SKU, there is a CC and CC1
if ((((input.Comments_Questions_to_Purchaser_Assistant != "") && (input.Request_Type != "Create new SKU")) && (input.Email_to_CC != "")) && (input.Email_to_CC1 != ""))
{
sendmail
(
To : input.Email_to_CC, input.Email_to_CC1
From : zoho.adminuserid
Subject : "Request # " + input.Request_Number + " - NEW Comments/Questions"
Message : "<div>NEW Comments/Questions : (" + input.Comments_Questions_Date_Time + ") " + input.Comments_Questions_to_Purchaser_Assistant + "</div>\n<div> </div>\n<div>Previous Notes: " + input.Comments_Questions + "</div>\n<div> </div>\n<div> </div>\n<div><strong><u>Request Details</u></strong></div>\n<div> </div>\n<div>Request Type : " + input.Request_Type + "</div>\n<div>Request sent to : " + input.Request_Assigned_To + "</div>\n<div> </div>\n<div>Request Date & Time :" + input.Request_Date_Time + "</div>\n<div>Requested By : " + input.Requested_By1 + "</div>\n<div>Deadline for Response : " + input.Deadline_for_Response + "</div>\n<div>Manufacturer Code : " + input.Manufacturer_Code + "</div>\n<div>Product Name : " + input.Product_Name + "</div>\n<div>Product Description : " + input.Product_Description + "</div>\n<div>Product Weblink : " + input.Product_Weblink + "</div>\n<div>Additional Notes : " + input.Additional_Notes + "</div>\n<div> </div>"
)
}