Creating Gift Voucher with Salesforce Marketing Cloud

Do you know the British clothing brand Boden? Well, I was a fan during 2 years and of course, I received tons of emails in that time.

 This weekend, I was sorting my mailbox and I saw this email below

Then one question comes in my mind: how to create this e-mail with Salesforce Marketing cloud? Let’s look at this together …

 1) Create a Data extension named



{Name= Couponcode ; Data type= Text; Length =100; Primary Key= True, Nullable= none; Default Value = none}

{Name= Isclaimed; Data type= Boolean; Length =none; Primary Key= false, Nullable= true; Default Value = False}

{Name= EmailAddress; Data type= EmailAddress; Length =none; Primary Key= false, Nullable= true; Default Value = none}

2) Create a list of coupon codes  like the ones below and save them in a  CSV file

3) After that, you can import the data in your Data extension create “ Codes Coupons”

To do that, return to your data extension and click on the “import” button.

4) For this last step in Email studio, add this AMPScript to your e-mail.


var @couponRow, @email,  @couponCode

set @email= AttributeValue(“EmailAddress”)

set @couponRow = ClaimRow(“CouponCodes”,“IsClaimed”, “EmailAddress”, @email)

if empty(@couponRow) then

RaiseError(“No coupon code”, false)


SET @couponCode = Field(@couponRow,“CouponCode”)



Your coupon code: %%=v(@couponCode)=%%

By the way, you can follow #Boden 🙂

Some pieces of the new collection here 🙂

See you soon with a new post!

Live with pleasure


One thought on “Creating Gift Voucher with Salesforce Marketing Cloud”

  1. Hi,

    I’ve been visiting your website a few times and decided to give you some positive feedback because I find it very useful. Well done.

    I was wondering if you as someone with experience of creating a useful website could help me out with my new site by giving some feedback about what I could improve?

    You can find my site by searching for “casino gorilla” in Google (it’s the gorilla themed online casino comparison).

    I would appreciate if you could check it out quickly and tell me what you think.

    Thank you for help and I wish you a great week!

Leave a Reply

Your email address will not be published. Required fields are marked *