Send TriggeredSend with data from DataExtension

Question

I currently have:

1. DataExtension
2. TriggeredSend
3. E-Mail template
4. All Subscriber List

---

What I now want to do is the following: I want to send a TriggeredSend and insert data into the E-Mail from the DataExtension. So let's say, that I have the data

Email hash: b642b4217b34b1e8d3bd915fc65c4452

I want that hash to appear in the TriggeredSend-Email. When editing an E-Mailtemplate I can only insert data from the All Subscrber List. However, I want to also insert data from the DataExtension into the E-Mail.

How would I do that? This has to be done without using the AllSubscriberList, because the user will only be added to that list, when he confirms the email by clicking on a link that I want to generate.

Answer 1

You'll need to use AMPScript in your email to retrieve the data from the Data Extension at send time. I have several examples here on my blog.

Here's the one that's most similar to your scenario:

%%[
var @DEColumn1, @lookupValue
set @lookupValue = "whee"
set @DEColumn1 = Lookup("DataExtensionName", "ReturnColumn", "LookupColumn", @lookupValue)

]%%
DEColumn1 is %%=v(@DEColumn1)=%%

EDIT: Lookup multiple columns:

%%[
var @rows, @row, @rowCount
var @lookupValue
set @lookupValue = "whee"

set @rows = LookupRows("DataExtensionName","LookupColumn", @lookupValue)
set @rowCount = rowcount(@rows)

if @rowCount > 0 then

var @DEColumn1, @DEColumn2
set @row = row(@rows,1) /* get row #1 */
set @DEColumn1 = field(@row,"DEColumn1")
set @DEColumn2 = field(@row,"DEColumn2")

]%%

DEColumn1 is %%=v(@DEColumn1)=%%, DEColumn2 is %%=v(@DEColumn2)=%%

%%[ else ]%%

No rows found

%%[ endif ]%%