I am a salesforce Developer and do not work with SFMC. We lost our SFMC resource and I have been trying to gen up to cover.

We have 2 Salesforce Objects: RequestType (RT) and RequestResponse (RR). The RequestType is a table that lists email campaigns that we are performing. The RequestResponse is data entered over a data loader which contains: RTID, LEADID, status and other data. This means that, for every email send we do, the data we need is a subset of RequestResponse__c data filtered on RTID.

These object are in SFMC as a Syncronised Data Extension.

I need to send a new email. I have learned that the syncronised data is unavailable to me for sending emails. I created a new DE for this and included a few key columns of data but... How do I get to the data in the SDE so that I can send an email?

  • 1
    A very straightforward option is to do a SQL query to populate your new DE from sync DE data. – Javier De Mauri Nov 17 '20 at 19:52
  • @JavierDeMauriThis actually helped. Thank you sir. – SeanGorman Nov 17 '20 at 21:30
  • Another option could be to build a journey that uses Salesforce data as an entry source listening on record creations or updates in Salesforce. – DonL Nov 18 '20 at 12:36
  • why is it unavailable? you may simply need to add ENT. to your data extension name in the ampscript – EazyE Nov 18 '20 at 12:39

You cannot select synchronised data extension for email sends. As people suggested you can use automation studio sql to populate your data extension, make sure the data extension is sendable and link the subscriber key (your unique identifier) to the corespondent field in the new data extension.

Else you should be able to filter the sync data extension via email studio.


You have 2 options. Filtering them or querying them if you have to join data from different objects.

If this is the case I would suggest you to install Query Studio, as it will make your life easier. Don't forget to use ent. in your SQL when queryng syncronized DE.

You can read more about Query studio here https://appexchange.salesforce.com/appxListingDetail?listingId=a0N3A00000FP3yFUAT

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.