So here's my use case: I need to send a weekly email containing all upcoming webcasts from our ecommerce site to our our subscriber base.
I have a file of website products and I have a separate DE of subscribers. I am populating an email dynamically using AMPscript - pointing to product file DE; however, the product file is not sendable because there arent any associated subscribers. When I select the DE of subscribers in the send email automation, the automation fails because it doesnt have all of the necessary product data.
Shouldnt I be able to populate an email with product data from one DE and send to another DE of subscribers?