Tag Archives: AmpScript

AMPscript – Count records in data extension, show percentages

I had a project where the client wanted the email recipient to take a simple survey by clicking on a certain link that answers the survey questions. It’s a way to fake a form in a sense. What is your … Continue reading

Posted in AmpScript, ExactTarget | Tagged , , , , , | Comments Off on AMPscript – Count records in data extension, show percentages

Pulling data from a data extension like a Relational table

Pulling data from a data extension: Pulling data from a data extension outside of the recipient list DE. Let’s say I have a DE that is my list of email recipeints and there is another DE with a list of … Continue reading

Posted in AmpScript, Email Dev, ExactTarget | Tagged , , | Comments Off on Pulling data from a data extension like a Relational table

Import data into a data extension using FTP

FTP data file into “import” folder In ET, go to “Interactions / Import” and click “Create” Name: Your choice File Naming Pattern: This is the name of the file you uploaded using FTP. Make sure to include file extension (.csv). … Continue reading

Posted in AmpScript, Email Dev, ExactTarget | Tagged , , , | Comments Off on Import data into a data extension using FTP

Adding possessive apostrophe to names – AMPscript

So we have some personalization in an email where we want to greet the recipient using their first name. In the example the first name was a pet name and the email was alerting the recipient that it was time … Continue reading

Posted in AmpScript, Email Dev, ExactTarget | Tagged , , , , , | Comments Off on Adding possessive apostrophe to names – AMPscript

ExactTarget AMPscript Base64 Encode

VAR @email, @encodedEmail, @DecodedEmail SET @email = emailaddr SET @encodedEmail = Base64Encode(@email) SET @DecodedEmail = Base64Decode(@encodedEmail) Email: %%= v(@email) =%% Encoded Email: %%= v(@encodedEmail) =%% Decoded Email: %%= v(@DecodedEmail) =%%

Posted in AmpScript, Email Dev, ExactTarget | Tagged , , , , | Comments Off on ExactTarget AMPscript Base64 Encode