E-mails cannot be sent as the records in this list are either not associated with a company or person or the associated record has no e-mail address

SOLVED

Hi,

Sage CRM 2018 R2:

I am getting this message "E-mails cannot be sent as the records in this list are either not associated with a company or person or the associated record has no e-mail address" when trying to send mass email using a group.

The group uses the following SQL : 

CREATE VIEW vPersonBulkImport
AS
SELECT P.Pers_PersonId,
P.Pers_CompanyId,
BI.[Person Reference No] AS pers_refno,
BI.Name AS pers_fullname,
BI.[Email Address] AS pers_email,
BI.[Company Name] AS comp_name,
BI.[Account Manager] AS account_manager,
BI.Type AS comp_type
FROM EMS.dbo.BulkImport BI
LEFT JOIN CRM.dbo.Person P ON BI.[Person Reference No] = P.pers_refno

On my testing the two people in the group are linked to a company and business email address.

Am I missing any fields in my group to get this working ? I thought the companyid and personid would be enough ?

Thanks

Chris

Parents Reply Children