Users as Part of an Email Campaign

We have 100's of users in Sales that are synced from the CRM.  We do monthly email newsletters campaigns that I would like Sales to see the emails as well.  That way if they get a question from the customer, they have a chance to know what the customer is referencing.  Users in Sales are constantly being added and many are in SM as contacts/leads but those are not synced to the CRM.  I created a report for Users so I can add them to the email delivery Recipients however I get an error stating that:

  • Report does not have Contacts.ContactID and Contacts.Email columns.

Is there a way around this because currently I need to add them as contacts/leads manually.  I would prefer to set it up so that it is automated.