Sending an email with dynamic content per recipient | Community
Skip to main content
Tara_Mason
Level 2
May 26, 2017
Question

Sending an email with dynamic content per recipient

  • May 26, 2017
  • 3 replies
  • 4716 views

Hello,

I am looking to see if I can send an email with specific dynamic content that is not in Marketo to 12 recipients.

Example: Email is all the same text except for 1 paragraph that contains a code specific for each of the 12 recipients. Is this possible? I tried to create a token script, but I was unable to match it to the specific email address of the recipient.

Dear so and so,

blah blah blah, please enter this 16 digit code xxxxx that is unique to you...

If a token is the correct way to go, how do I match that token to the lead in Marketo? Token A is dynamic to lead A.


Do I have to do this old school and send an email merge?

Thanks for your help!

Tara

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

3 replies

Chris_Saporito
Level 7
May 26, 2017

One way I've done this in the past that is relatively quick is to create a re-usable field in Marketo specifically for projects like this. You can name is "Misc. Field #1" or whatever you decide. Then you can put together an excel doc with the 12 recipients and naming the column with the code "Misc. Field #1" so that when you upload the list into the campaign it will populate that field. Once you do that you can then token that field into your email. Might not be the proper way to do this but it does the job somewhat quickly.

Tara_Mason
Level 2
May 26, 2017

Ah, yes. Didn't think of it that way. I agree, a quick easy way to get the job done!

Thanks Chris!

SanfordWhiteman
Level 10
May 26, 2017

You could do it Chris's way, but there's no reason this wouldn't work in a Velocity script:

#if( $lead.Email == "firstaddy​@​grunk.com" )

First content

#elseif( $lead.Email == "secondaddy​@​henk.com" )

Second content

#elseif( $lead.Email == "thirdaddy​@​jonk.com" )

Third content

#else

Default Content

#end

Tara_Mason
Level 2
May 30, 2017

I am not too sure about the velocity script. I took Chris' suggestion.

The only problem I am having now is my csv upload. I receive an error that the data field basically isn't long enough to hold the code. Here is the exact description: "Value is greater than allowed for field". I have tried to locate more info on this but to no avail. I did not notice any section where I can input the 18 digit limit and assign it to the field.

Is there such a thing? is there a maximum?

Thanks for your assistance.

Tara

SanfordWhiteman
Level 10
May 31, 2017

I am not too sure about the velocity script.

What's there to be unsure about?

The only problem I am having now is my csv upload. I receive an error that the data field basically isn't long enough to hold the code. Here is the exact description: "Value is greater than allowed for field". I have tried to locate more info on this but to no avail. I did not notice any section where I can input the 18 digit limit and assign it to the field.

Is there such a thing? is there a maximum?

The maximum length of a field is dictated by its data type.

If this is a numeric field, you can't insert 18 digits into it. The maximum value of a (signed) integer is 2147483647, which in addition to prohibiting any larger integers also means there can never be any values longer than 10 digits.

September 18, 2017

did text field work instead?