Mdthbs

Check disk usage of files returned with spaces

Regression when x and y each have uncertainties

Pocket Clarketech

The Roommates' Dilemma

Do I need to start off my book by describing the character's "normal world"?

What does a comma signify in inorganic chemistry?

Representing an indicator function: binary variables and "indicator constraints"

Can I submit a paper computer science conference using an alias if using my real name can cause legal trouble in my original country

What if a restaurant suddenly cannot accept credit cards, and the customer has no cash?

Quick destruction of a helium filled airship?

Does the Temple of the Gods spell nullify critical hits?

Unconventional examples of mathematical modelling

From where do electrons gain kinetic energy through a circuit?

Has there ever been a truly bilingual country prior to the contemporary period?

Meaning and structure of headline "Hair it is: A List of ..."

Rotate List by K places

Why can't I see 1861 / 1871 census entries on Freecen website when I can see them on Ancestry website?

How does the illumination of the sky from the sun compare to that of the moon?

What is the opposite of "hunger level"?

Number of matrices with bounded products of rows and columns

Did they ever see Truman doing any private things when filming him for 24 hours 7 days a week?

Programming a recursive formula into Mathematica and find the nth position in the sequence

μονάδαι as plural form of μονάς

What's a good pattern to calculate a variable only when it is used the first time?

Stop email from sending using AMPscript

RaiseError - Will it stop email from sendingRender Email AMPScript without sending“Fatigue” Rules on Content in Marketing Cloud? (AMPscript)How to stop Marketing Cloud from canceling activities if one single email send fails?sending an email with example personalization string, stop Ampscript from interpreting the percent signsUsing AmpScript to populate email from Data ExtensionRetrieving Salesforce Objects with AMPScriptUpdate Email within a TriggeredSend

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}

1

I have a journey which sends an email. The email contains an AMPscript pulling content blocks in. Is is possible to NOT sent the email if there are no content blocks in the email?

SET @CONTACT_ID = CONTACT_ID

SET @Rows_tv2 = LookupRows("TR_VELKOMST_VAS_MAIL_SUBS_tv2","CONTACT_ID", @CONTACT_ID)

SET @Rows_wype = LookupRows("TR_VELKOMST_VAS_MAIL_SUBS_Wype","CONTACT_ID", @CONTACT_ID)

SET @Rows_deezer = LookupRows("TR_VELKOMST_VAS_MAIL_SUBS_Deezer","CONTACT_ID", @CONTACT_ID)



IF RowCount(@Rows_tv2) == 0 then

SET @tv2_block = ContentBlockbyID(28651) 



  ENDIF



IF RowCount(@Rows_wype) == 0 then

SET @wype_block = ContentBlockbyID(26469) 



  ENDIF



IF RowCount(@Rows_deezer) == 0 then

SET @deezer_block = ContentBlockbyID(25834) 



  ENDIF



   ]%%



%%=v(@tv2_block)=%%

%%=v(@wype_block)=%%

%%=v(@deezer_block)=%%

So if

@Rows_tv2 > 0 AND
@Rows_wype > 0 AND
@Rows_deezer > 0

THEN DONT SEND EMAIL

marketing-cloud email ampscript journeybuilder

share|improve this question

edited 2 days ago

Martin Ho

asked 2 days ago

Martin HoMartin Ho

3988 bronze badges

add a comment | 

1

I have a journey which sends an email. The email contains an AMPscript pulling content blocks in. Is is possible to NOT sent the email if there are no content blocks in the email?

SET @CONTACT_ID = CONTACT_ID

SET @Rows_tv2 = LookupRows("TR_VELKOMST_VAS_MAIL_SUBS_tv2","CONTACT_ID", @CONTACT_ID)

SET @Rows_wype = LookupRows("TR_VELKOMST_VAS_MAIL_SUBS_Wype","CONTACT_ID", @CONTACT_ID)

SET @Rows_deezer = LookupRows("TR_VELKOMST_VAS_MAIL_SUBS_Deezer","CONTACT_ID", @CONTACT_ID)



IF RowCount(@Rows_tv2) == 0 then

SET @tv2_block = ContentBlockbyID(28651) 



  ENDIF



IF RowCount(@Rows_wype) == 0 then

SET @wype_block = ContentBlockbyID(26469) 



  ENDIF



IF RowCount(@Rows_deezer) == 0 then

SET @deezer_block = ContentBlockbyID(25834) 



  ENDIF



   ]%%



%%=v(@tv2_block)=%%

%%=v(@wype_block)=%%

%%=v(@deezer_block)=%%

So if

@Rows_tv2 > 0 AND
@Rows_wype > 0 AND
@Rows_deezer > 0

THEN DONT SEND EMAIL

marketing-cloud email ampscript journeybuilder

share|improve this question

edited 2 days ago

Martin Ho

asked 2 days ago

Martin HoMartin Ho

3988 bronze badges

add a comment | 

I have a journey which sends an email. The email contains an AMPscript pulling content blocks in. Is is possible to NOT sent the email if there are no content blocks in the email?

SET @CONTACT_ID = CONTACT_ID

SET @Rows_tv2 = LookupRows("TR_VELKOMST_VAS_MAIL_SUBS_tv2","CONTACT_ID", @CONTACT_ID)

SET @Rows_wype = LookupRows("TR_VELKOMST_VAS_MAIL_SUBS_Wype","CONTACT_ID", @CONTACT_ID)

SET @Rows_deezer = LookupRows("TR_VELKOMST_VAS_MAIL_SUBS_Deezer","CONTACT_ID", @CONTACT_ID)



IF RowCount(@Rows_tv2) == 0 then

SET @tv2_block = ContentBlockbyID(28651) 



  ENDIF



IF RowCount(@Rows_wype) == 0 then

SET @wype_block = ContentBlockbyID(26469) 



  ENDIF



IF RowCount(@Rows_deezer) == 0 then

SET @deezer_block = ContentBlockbyID(25834) 



  ENDIF



   ]%%



%%=v(@tv2_block)=%%

%%=v(@wype_block)=%%

%%=v(@deezer_block)=%%

So if

@Rows_tv2 > 0 AND
@Rows_wype > 0 AND
@Rows_deezer > 0

THEN DONT SEND EMAIL

marketing-cloud email ampscript journeybuilder

share|improve this question

edited 2 days ago

Martin Ho

asked 2 days ago

Martin HoMartin Ho

3988 bronze badges

SET @CONTACT_ID = CONTACT_ID

SET @Rows_tv2 = LookupRows("TR_VELKOMST_VAS_MAIL_SUBS_tv2","CONTACT_ID", @CONTACT_ID)

SET @Rows_wype = LookupRows("TR_VELKOMST_VAS_MAIL_SUBS_Wype","CONTACT_ID", @CONTACT_ID)

SET @Rows_deezer = LookupRows("TR_VELKOMST_VAS_MAIL_SUBS_Deezer","CONTACT_ID", @CONTACT_ID)



IF RowCount(@Rows_tv2) == 0 then

SET @tv2_block = ContentBlockbyID(28651) 



  ENDIF



IF RowCount(@Rows_wype) == 0 then

SET @wype_block = ContentBlockbyID(26469) 



  ENDIF



IF RowCount(@Rows_deezer) == 0 then

SET @deezer_block = ContentBlockbyID(25834) 



  ENDIF



   ]%%



%%=v(@tv2_block)=%%

%%=v(@wype_block)=%%

%%=v(@deezer_block)=%%

share|improve this question

edited 2 days ago

Martin Ho

asked 2 days ago

Martin HoMartin Ho

3988 bronze badges

share|improve this question

edited 2 days ago

Martin Ho

asked 2 days ago

Martin HoMartin Ho

3988 bronze badges

asked 2 days ago

Martin HoMartin Ho

3988 bronze badges

asked 2 days ago

Martin HoMartin Ho

3988 bronze badges

2 Answers
2

active

oldest

votes

6

I would recommend using Exclusion Scripts if possible. You can find a good explanation of the feature in this video by Eliot Harper.

The exclusion script will be executed prior to sending the email, hence the email sends will not be counted towards your supermessage limits. If you are using RaiseError, the email sends will still count, but the email will of course not be sent.

Both solutions will help you achieve what you need, and I admit that RaiseError will in some cases be easier to implement.

share|improve this answer

answered 2 days ago

Lukas LunowLukas Lunow

4,86522 gold badges77 silver badges2323 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Hi Lukas - This is perfect! Thanks. I will try this out right away!
  
  – Martin Ho
  2 days ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I managed to make it work. Thank you very much!
  
  – Martin Ho
  2 days ago
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Det var så lidt, @MartinHo!
  
  – Lukas Lunow
  2 days ago
  

  
  
  
  

add a comment | 

4

Have you tried using the RaiseError function to skip the send to that subscriber when there is no content available?

if empty(@YourContent) then

RaiseError('Error message', true)

endif

Good usage example here:
https://ampscript.guide/raiseerror/

share|improve this answer

answered 2 days ago

DaithíDaithí

4111 bronze badge

New contributor

Daithí is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Hi Daithi - Thank you for your input. I've looked at the funktion and it would work, but it would count the supressed emails as sent and therefore I can't use it.
  
  – Martin Ho
  2 days ago
  

  
  
  
  

add a comment | 

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "459"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsalesforce.stackexchange.com%2fquestions%2f273729%2fstop-email-from-sending-using-ampscript%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

6

I would recommend using Exclusion Scripts if possible. You can find a good explanation of the feature in this video by Eliot Harper.

The exclusion script will be executed prior to sending the email, hence the email sends will not be counted towards your supermessage limits. If you are using RaiseError, the email sends will still count, but the email will of course not be sent.

Both solutions will help you achieve what you need, and I admit that RaiseError will in some cases be easier to implement.

share|improve this answer

answered 2 days ago

Lukas LunowLukas Lunow

4,86522 gold badges77 silver badges2323 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Hi Lukas - This is perfect! Thanks. I will try this out right away!
  
  – Martin Ho
  2 days ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I managed to make it work. Thank you very much!
  
  – Martin Ho
  2 days ago
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Det var så lidt, @MartinHo!
  
  – Lukas Lunow
  2 days ago
  

  
  
  
  

add a comment | 

6

I would recommend using Exclusion Scripts if possible. You can find a good explanation of the feature in this video by Eliot Harper.

The exclusion script will be executed prior to sending the email, hence the email sends will not be counted towards your supermessage limits. If you are using RaiseError, the email sends will still count, but the email will of course not be sent.

Both solutions will help you achieve what you need, and I admit that RaiseError will in some cases be easier to implement.

share|improve this answer

answered 2 days ago

Lukas LunowLukas Lunow

4,86522 gold badges77 silver badges2323 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Hi Lukas - This is perfect! Thanks. I will try this out right away!
  
  – Martin Ho
  2 days ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I managed to make it work. Thank you very much!
  
  – Martin Ho
  2 days ago
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Det var så lidt, @MartinHo!
  
  – Lukas Lunow
  2 days ago
  

  
  
  
  

add a comment | 

I would recommend using Exclusion Scripts if possible. You can find a good explanation of the feature in this video by Eliot Harper.

The exclusion script will be executed prior to sending the email, hence the email sends will not be counted towards your supermessage limits. If you are using RaiseError, the email sends will still count, but the email will of course not be sent.

Both solutions will help you achieve what you need, and I admit that RaiseError will in some cases be easier to implement.

share|improve this answer

answered 2 days ago

Lukas LunowLukas Lunow

4,86522 gold badges77 silver badges2323 bronze badges

share|improve this answer

answered 2 days ago

Lukas LunowLukas Lunow

4,86522 gold badges77 silver badges2323 bronze badges

answered 2 days ago

Lukas LunowLukas Lunow

4,86522 gold badges77 silver badges2323 bronze badges

answered 2 days ago

Lukas LunowLukas Lunow

4,86522 gold badges77 silver badges2323 bronze badges

4

Have you tried using the RaiseError function to skip the send to that subscriber when there is no content available?

if empty(@YourContent) then

RaiseError('Error message', true)

endif

Good usage example here:
https://ampscript.guide/raiseerror/

share|improve this answer

answered 2 days ago

DaithíDaithí

4111 bronze badge

New contributor

Daithí is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Hi Daithi - Thank you for your input. I've looked at the funktion and it would work, but it would count the supressed emails as sent and therefore I can't use it.
  
  – Martin Ho
  2 days ago
  

  
  
  
  

add a comment | 

4

Have you tried using the RaiseError function to skip the send to that subscriber when there is no content available?

if empty(@YourContent) then

RaiseError('Error message', true)

endif

Good usage example here:
https://ampscript.guide/raiseerror/

share|improve this answer

answered 2 days ago

DaithíDaithí

4111 bronze badge

New contributor

Daithí is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Hi Daithi - Thank you for your input. I've looked at the funktion and it would work, but it would count the supressed emails as sent and therefore I can't use it.
  
  – Martin Ho
  2 days ago
  

  
  
  
  

add a comment | 

Have you tried using the RaiseError function to skip the send to that subscriber when there is no content available?

if empty(@YourContent) then

RaiseError('Error message', true)

endif

Good usage example here:
https://ampscript.guide/raiseerror/

share|improve this answer

answered 2 days ago

DaithíDaithí

4111 bronze badge

New contributor

Daithí is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

if empty(@YourContent) then

RaiseError('Error message', true)

endif

share|improve this answer

answered 2 days ago

DaithíDaithí

4111 bronze badge

New contributor

Daithí is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

answered 2 days ago

DaithíDaithí

4111 bronze badge

New contributor

Daithí is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

answered 2 days ago

DaithíDaithí

4111 bronze badge