MarTechFriday

Whitespaces and Email Salutation Tokens Scripts - #MarTechFriday 2018-33

1,220 views
Different combinations of not having a stored value for MiddleName and/or Salutation can lead to unwanted extra whitespaces in your email opening. You can address this with formula field tokens or velocity email scripting.

This video has some @Marketo related topics, but could also apply to other marketing automation platforms.

[[German example]]
#if ( ${lead.LastName} ne "" && ${lead.Salutation} eq "Herr" )
Sehr geehrter ${lead.Salutation} ${lead.LastName},
#elseif ( ${lead.LastName} ne "" && ${lead.Salutation} eq "Frau" )
Sehr geehrte ${lead.Salutation} ${lead.LastName},
#else
Sehr geehrte Damen und Herren,
#end

[[English Example]]
#if ( ${lead.Salutation} ne "" && ${lead.MiddleName} ne "" && ${lead.LastName} ne "" )
Dear ${lead.Salutation} ${lead.MiddleName} ${lead.LastName},
#elseif ( ${lead.Salutation} eq "" && ${lead.MiddleName} ne "" && ${lead.LastName} ne "" )
Dear Sir or Madam ${lead.MiddleName} ${lead.LastName},
#elseif ( ${lead.Salutation} ne "" && ${lead.MiddleName} eq "" && ${lead.LastName} ne "" )
Dear ${lead.Salutation} ${lead.LastName},
#elseif ( ${lead.Salutation} eq "" && ${lead.MiddleName} eq "" && ${lead.LastName} ne "" )
Dear Sir or Madam ${lead.LastName},
#elseif ( ${lead.Salutation} eq "" && ${lead.MiddleName} eq "" && ${lead.LastName} eq "" )
Dear Sir or Madam,
#elseif ( ${lead.Salutation} eq "" && ${lead.MiddleName} ne "" && ${lead.LastName} eq "" )
Dear Sir or Madam,
#elseif ( ${lead.Salutation} ne "" && ${lead.MiddleName} eq "" && ${lead.LastName} eq "" )
Dear ${lead.Salutation},
#else
Dear Sir or Madam,
#end

danywick February 25, 2020 07:21 AM Delete

I think this is an informative post and it is very useful and knowledgeable. therefore, I would like to thank you for the efforts you have made in writing this article. Todd Snively

harry February 25, 2020 06:39 AM Delete

I was surfing the Internet for information and came across your blog. I am impressed by the information you have on this blog. It shows how well you understand this subject. hvac companies in Orlando Florida

harry February 25, 2020 04:21 AM Delete

I think this is an informative post and it is very useful and knowledgeable. therefore, I would like to thank you for the efforts you have made in writing this article. sagaming666

abdul wahab February 24, 2020 06:03 PM Delete

Right away this website will probably unquestionably usually become well known with regards to most of website customers, as a result of meticulous accounts and in addition tests. thai food

abdul wahab February 24, 2020 05:18 PM Delete

Swiftly this amazing site may well definitely turn out to be well-known between almost all writing a blog men and women, for your careful content and even assessments. tacotime

abdul wahab February 24, 2020 04:24 PM Delete

Right away this website will probably unquestionably usually become well known with regards to most of website customers, as a result of meticulous accounts and in addition tests. tacotime

February 24, 2020 04:00 PM Delete

Thanks for picking out the time to discuss this, I feel great about it and love studying more on this topic. It is extremely helpful for me. Thanks for such a valuable help again. Todd Snively

abdul wahab February 24, 2020 03:28 PM Delete

Right away this website will probably unquestionably usually become well known with regards to most of website customers, as a result of meticulous accounts and in addition tests. blimpie

dorissoto February 24, 2020 12:44 PM Delete

These you will then see the most important thing, the application provides you a website a powerful important internet page: Pecannoten

dorissoto February 24, 2020 12:42 PM Delete

Hmm… I interpret blogs on a analogous issue, however i never visited your blog. I added it to populars also i’ll be your faithful primer. Isolatiechappe

dorissoto February 24, 2020 12:38 PM Delete

Interesting and interesting information can be found on this topic here profile worth to see it. Havervlokken

Adilkhatri February 24, 2020 12:26 PM Delete

Thankful to you for your post, I look for such article along time, today I find it finally. this post give me piles of provoke it is to a great degree supportive for me. 릴게임

dorissoto February 24, 2020 11:33 AM Delete

I prefer merely excellent resources - you will see these people in: Pistachenoten

harry February 24, 2020 09:49 AM Delete

Superbly written article, if only all bloggers offered the same content as you, the internet would be a far better place.. How To Check If Your Nintendo Switch Is Charging

mtom February 24, 2020 08:21 AM Delete

I’m curious to find out what blog system you happen to be utilizing? I’m having some small security problems with my latest blog and I’d like to find something more safe. Do you have any solutions? HMHB


--------------------------------------------------------------------------------------------------------------------------------------------------------------------

I really treasure your piece of work, Great post. https://isum.com/buy-cbd-oil-near-me/

harry February 24, 2020 07:57 AM Delete

Great job for publishing such a beneficial web site. Your web log isn’t only useful but it is additionally really creative too. bad smell removal with ozone

February 24, 2020 07:20 AM Delete

Unbelievable Blog! I should need to thank for the undertakings you have made in creating this post. I am believing a comparable best work from you later on moreover. I expected to thank you for this destinations! Thankful for sharing. Amazing destinations! 토토사이트

harry February 24, 2020 06:08 AM Delete

I was surfing the Internet for information and came across your blog. I am impressed by the information you have on this blog. It shows how well you understand this subject. dominoqq online

dorissoto February 23, 2020 12:38 PM Delete

Acknowledges for paper such a beneficial composition, I stumbled beside your blog besides decipher a limited announce. I want your technique of inscription... Cashewnoten

dorissoto February 23, 2020 12:32 PM Delete

Within this webpage, you'll see the page, you need to understand this data. Walnoten

dorissoto February 23, 2020 12:26 PM Delete

Mmm.. estimable to be here in your report or notify, whatever, I repute I should moreover process strong for my have website want I play some salubrious further updated busy in your location. Amandelen

harry February 23, 2020 11:27 AM Delete

You there, this is really good post here. Thanks for taking the time to post such valuable information. Quality content is what always gets the visitors coming. publish guest post

abdul wahab February 23, 2020 11:13 AM Delete

Swiftly this amazing site may well definitely turn out to be well-known between almost all writing a blog men and women, for your careful content and even assessments. ตรวจ สลากกินแบ่ง รัฐบาล

harry February 23, 2020 10:38 AM Delete

This content is written very well. Your use of formatting when making your points makes your observations very clear and easy to understand. Thank you. twitter video downloader

harry February 23, 2020 10:33 AM Delete

Pretty good post. I have just stumbled upon your blog and enjoyed reading your blog posts very much. I am looking for new posts to get more precious info. Big thanks for the useful info. synthetic wigs

Hassan February 23, 2020 08:53 AM Delete

I wanted to thank you for this great read!! I definitely enjoying every little bit of it I have you bookmarked to check out new stuff you post. Kevin David

harry February 23, 2020 08:51 AM Delete

I appreciate everything you have added to my knowledge base.Admiring the time and effort you put into your blog and detailed information you offer.Thanks. زيادة متابعين تيك توك

harry February 23, 2020 08:17 AM Delete

This is such a great resource that you are providing and you give it away for free. I love seeing blog that understand the value of providing a quality resource for free. 사다리사이트

February 23, 2020 07:30 AM Delete

일산가라오케 일산룸 정찰제 가격으로 운영하는 노래방 추천, ☎ 010-4144-6573 | 일산가라오케 최고 시스템 | 일산룸카페 | 일산노래방. 일산가라오케

dorissoto February 23, 2020 07:13 AM Delete

This is very interesting content! I have thoroughly enjoyed reading your points and have come to the conclusion that you are right about many of them. You are great. Chape

hammad February 23, 2020 07:07 AM Delete

예전 실시간게임 은 네임드의 사다리, 다리다리 가 대표적이고 대중적이였다면

현재 동행복권 게임들이 아주 큰 인기와 사랑을 받고 있습니다.

파워볼사이트

February 23, 2020 06:07 AM Delete

Mmm.. estimable to be here in your report or notify, whatever, I repute I should moreover process strong for my have website want I play some salubrious further updated busy in your location. 샌즈카지노

johan February 23, 2020 05:08 AM Delete

Profit primarily prime quality items -- you can understand them all within: click here

shahzaibsk February 22, 2020 06:17 PM Delete

For many people this is important, so check out my profile: http://linkalternatifjudi.top

abdul wahab February 22, 2020 02:50 PM Delete

Once i received on your own website despite the fact that inserting attention simply a bit small bit submits. Pleasurable technique for lasting, I will be book-marking at any moment receive sorts full will come way up. huay

RankXone February 22, 2020 12:09 PM Delete

Most of the plumbing related tasks require an experienced service provider. If you can hire such a qualified service provider, you will be able to minimize the time and effort taken to get the job done as well. Hence, you need to take a look at the length of time in the business that your plumbing company has been. Sydney plumber

harrry33 February 22, 2020 11:19 AM Delete

This is such a great resource that you are providing and you give it away for free. I love seeing blog that understand the value of providing a quality resource for free. viagra kaufen

rick February 22, 2020 10:09 AM Delete

The JNVST Result link will be provided on the official website of JNVST i.e. navodaya.gov.in. Students will be able to download the Navodaya Result 2020 Patna Selection List by entering their Roll Number and Date of Birth. Once the official authority has declared the result date. We will provide you the information on the Navodaya Result Date in this article.

dorissoto February 22, 2020 09:50 AM Delete

In this article understand the most important thing, the item will give you a keyword rich link a great useful website page: iphone png

Turismo dentale February 22, 2020 08:46 AM Delete

This is my first time visit here. From the tons of comments on your articles,I guess I am not only one having all the enjoyment right here! drocha.tv/drocha/2019/ 2019

jojolei February 22, 2020 08:02 AM Delete

I simply want to tell you that I am new to weblog and definitely liked this blog site. Very likely I’m going to bookmark your blog . You absolutely have wonderful stories. Cheers for sharing with us your blog. 코인카지노

harrry33 February 22, 2020 07:49 AM Delete

This is such a great resource that you are providing and you give it away for free. I love seeing blog that understand the value of providing a quality resource for free. zatrahal.online/brazzers/

vidmate February 22, 2020 05:31 AM Delete

href="https://vidmate.ltd/">vidmate

basit February 21, 2020 07:13 PM Delete

Short Hairstyles for Girls have always remained in fashion from every now and then. Deciding to have a short haircut is a choice that is considered as a bold step in this typical stereotype society.

girls short haircuts

jojolei February 21, 2020 05:45 PM Delete

Thankful to you for your post, I look for such article along time, today I find it finally. this post give me piles of provoke it is to a great degree supportive for me. 토토

abdul wahab February 21, 2020 04:22 PM Delete

Effortlessly these pages will likely definitely probably become well-known concerning several sites people, for the careful content or even thoughts. หวย

mtom February 21, 2020 11:06 AM Delete

Great post. I was checking continuously this blog and I’m impressed! Extremely helpful info particularly the last part I care for such information a lot. I was seeking this particular info for a very long time. Thank you and best of luck. CBD pills

dssd February 20, 2020 08:01 PM Delete

Yes i am totally agreed with this article and i just want say that this article is very nice and very informative article.I will make sure to be reading your blog more. You made a good point but I can't help but wonder, what about the other side? !!!!!!Thanks adult store india

Adilkhatri February 20, 2020 12:30 PM Delete

Great info! I recently came across your blog and have been reading along. I thought I would leave my first comment. I don’t know what to say except that I have. 먹튀검증

Adilkhatri February 20, 2020 10:27 AM Delete

신용카드현금화 ✓ 소액결제현금화 ✓ 소액휴대폰결제현금화 ✓ 정보이용료현금화 ✓ 문화상품권현금화 ✓ 상품권매입 ✓ 소액결제현금화사이트 ✓ 신용카드현금화사이트 신용카드현금화

dorissoto February 20, 2020 10:03 AM Delete

I personally use them exclusively high-quality elements : you will notice these folks during: Chape Limburg

dorissoto February 20, 2020 10:01 AM Delete

Below you will understand what is important, the idea provides one of the links with an exciting site: Isolatiechape

dorissoto February 20, 2020 09:45 AM Delete

Nice information, valuable and excellent design, as share good stuff with good ideas and concepts, lots of great information and inspiration, both of which I need, thanks to offer such a helpful information here. Zwembaden Antwerpen

harry February 20, 2020 08:15 AM Delete

This is certainly as well a really good posting we seriously experienced looking through. It is far from on a daily basis we have risk to check out a little something. singapore prize

johan February 20, 2020 04:58 AM Delete

For many people this is the best solution here see how to do it. click here more

shahzaibsk February 19, 2020 07:59 PM Delete

Amazing, this is great as you want to learn more, I invite to This is my page. guest post

Adilkhatri February 19, 2020 12:57 PM Delete

Thanks for posting this info. I just want to let you know that I just check out your site and I find it very interesting and informative. I can't wait to read lots of your posts. 메이저놀이터

harry February 19, 2020 11:01 AM Delete

Thanks for an interesting blog. What else may I get that sort of info written in such a perfect approach? I have an undertaking that I am just now operating on, and I have been on the lookout for such info. drocha.tv/drocha/krasotki/

samharries February 19, 2020 10:28 AM Delete

A debt of gratitude is in order for the significant data and experiences you have so given here... game candy crush saga download

dorissoto February 19, 2020 10:08 AM Delete

Great info! I recently came across your blog and have been reading along. I thought I would leave my first comment. I don’t know what to say except that I have. Chapewerken

merckseo February 19, 2020 09:52 AM Delete

I have to look for goals with essential information on given point and offer them to instructor our inclination and the article. it avtal

harry February 19, 2020 08:45 AM Delete

Thanks for picking out the time to discuss this, I feel great about it and love studying more on this topic. It is extremely helpful for me. Thanks for such a valuable help again. Alabama Background Check

엔트리 파워 볼 February 19, 2020 08:29 AM Delete

Hello, I just wanted to compliment you on your excellent website. As of now, this is one of the most unique and informative sites that I visited this year. As you have a Fascinating content and very well laid out and it was easy to read. You should be commended for all of your efforts. Take care and I wish you the best in your current and future endeavours. 엔트리 파워 볼 || 엔트리 파워 볼 || 엔트리 파워 볼

Adilkhatri February 19, 2020 08:16 AM Delete

ForSaleInEdmonton is a Realtor website for one of Edmonton's top realtors Logan Patterson. This website is for listing real estate In Edmonton. There are 3 listing services to help you sell your home faster. Edmonton Real Estate

abdul wahab February 19, 2020 07:34 AM Delete

Because of this , appear you should important researching previously penning. It's possible in order to healthier put up in such a manner. Movies and Filmywap

harry February 19, 2020 05:57 AM Delete

You have outdone yourself this time. It is probably the best, most short step by step guide that I have ever seen. singapore prize

harry February 19, 2020 04:35 AM Delete

Thanks for an interesting blog. What else may I get that sort of info written in such a perfect approach? I have an undertaking that I am just now operating on, and I have been on the lookout for such info. drocha.tv/drocha/krasotki/

dds February 18, 2020 03:14 PM Delete

Great, thanks for sharing this blog post.Thanks Again. Keep writing. 도도그래프

dds February 18, 2020 03:14 PM Delete

Major thanks for the blog.Much thanks again. Cool. music production

abdul wahab February 18, 2020 02:05 PM Delete

This really is similarly a great content material we very truly loved looking at. This is not constantly that we have possible to sort out a problem. baja fresh

faizakhan February 18, 2020 11:58 AM Delete

If you are looking for more information about flat rate locksmith Las Vegas check that right away. menards tm

faizakhan February 18, 2020 11:35 AM Delete

You make so many great points here that I read your article a couple of times. Your views are in accordance with my own for the most part. This is great content for your readers. menards human resources

harrry33 February 18, 2020 11:05 AM Delete

I read that Post and got it fine and informative. joinhoky.com

abdul wahab February 18, 2020 11:04 AM Delete

This really is similarly a great content material we very truly loved looking at. This is not constantly that we have possible to sort out a problem. pinkberry

harrry33 February 18, 2020 08:47 AM Delete

Great content material and great layout. Your website deserves all of the positive feedback it’s been getting. boltless rack

Hassan February 18, 2020 08:24 AM Delete

Your texts on this subject are correct, see how I wrote this site is really very good. Aanleg zwembad

harrry33 February 18, 2020 07:03 AM Delete

I think this is an informative post and it is very useful and knowledgeable. therefore, I would like to thank you for the efforts you have made in writing this article. piermont grand price list

harrry33 February 18, 2020 05:09 AM Delete

You have outdone yourself this time. It is probably the best, most short step by step guide that I have ever seen. instagram growth service

harrry33 February 18, 2020 04:41 AM Delete

nice post, keep up with this interesting work. It really is good to know that this topic is being covered also on this web site so cheers for taking time to discuss this! piermont grand location

shahzaibsk February 17, 2020 07:34 PM Delete

Interestingly you write, I will address you'll find exciting and interesting things on similar topics. high DR guest post

harrry33 February 17, 2020 11:56 AM Delete

DCondo Sign One Stop Service - Sell and Rent D Condo Sign Chiang Mai Because chiangmai condo for rent provides hundreds of condo and apartment for rent and sale in Chiang Mai.Save your time and money looking for properties in Chiangmai . sale dcondo sign

harrry33 February 17, 2020 10:35 AM Delete

Dashiki Store sale white dashiki shirts and black dashiki shirts which suitable for dashiki for men and dashiki womens. african dashiki shirts

CBD oil February 17, 2020 08:41 AM Delete

Mind boggling posting this is from you. I am truly and genuinely excited to peruse this wonderful post. You've truly intrigued me today. I trust you'll keep on doing as such! one Holland village

harrry33 February 17, 2020 06:26 AM Delete

This is such a great resource that you are providing and you give it away for free. I love seeing blog that understand the value of providing a quality resource for free. online marketing

saasas February 16, 2020 05:52 PM Delete

I can see that you are an expert at your field! I am launching a website soon, and your information will be very useful for me.. Thanks for all your help and wishing you all the success in your business. http://drochila.online/brazzers/

Asad February 16, 2020 10:20 AM Delete

Gives you the best website address I know there alone you'll find how easy it is. Polyester zwembad

abdul wahab February 16, 2020 10:05 AM Delete

I know this is one of the most meaningful information for me. And I'm animated reading your article. But should remark on some general things, the website style is perfect; the articles are great. Thanks for the ton of tangible and attainable help. 클럽

jojolei February 16, 2020 05:23 AM Delete

It's exceptionally useful and you are clearly extremely proficient around there. You have opened my eyes to shifting perspectives on this point with intriguing and strong substance. Richardson

harry February 16, 2020 05:17 AM Delete

All your hard work is much appreciated. Nobody can stop to admire you. Lots of appreciation. Star Carat Diamonds Review

Asad February 15, 2020 08:53 PM Delete

I have a similar interest this is my page read everything carefully and let me know what you think. singapore brazilian hair removal

Fury vs Wilder II Live February 15, 2020 07:36 PM Delete

The official telecast partner of the Fury vs Wilder II is ESPN PPV and Fox PPV jointly. The rematch will be telecast from the MGM Grand Garden. The boxing fans of the United States can stream. the Fury vs Wilde 2 on FOX PPV and BT Sport Box Office will air the rematch in the United Kingdom Fury vs Wilder 2 Live Free

faizakhan February 15, 2020 11:50 AM Delete

Thanks for a very interesting blog. What else may I get that kind of info written in such a perfect approach? I’ve a undertaking that I am simply now operating on, and I have been at the look out for such info. jcpassociates.com

faizakhan February 15, 2020 11:33 AM Delete

This is a great inspiring article.I am pretty much pleased with your good work.You put really very helpful information. Keep it up. Keep blogging. Looking to reading your next post. jcpenney jtime

dorissoto February 15, 2020 10:49 AM Delete

These things are very important, good think so - I think so too... Zwembad aanleggen

dorissoto February 15, 2020 10:39 AM Delete

Acknowledges for penmanship such a worthy column, I stumbled beside your blog besides predict a handful advise. I want your tone of manuscript... Polypropyleen zwembad

dorissoto February 15, 2020 10:36 AM Delete

I really appreciate this wonderful post that you have provided for us. I assure this would be beneficial for most of the people. Monoblock zwembad

dorissoto February 15, 2020 10:25 AM Delete

Initial You got a awesome blog .I determination be involved in plus uniform minutes. i view you got truly very functional matters , i determination be always checking your blog blesss. Pizza eten Hasselt

dorissoto February 15, 2020 10:18 AM Delete

Great info! I recently came across your blog and have been reading along. I thought I would leave my first comment. I don’t know what to say except that I have. Polypropyleen zwembad

Add a comment...
Post as (log out)