Execu/Tech Systems, Inc.
Knowledgebase
Search:
850-747-0581 Email Website
Contents
 
:
IndexBookmarkPrint This Article

Home > Execu/Suite Hotel PMS > Exec/Email > Email Marketing Merge Fields

 

Email Marketing Merge Fields

​

If you choose to integrate with Execu/Tech's email marketing service, and want to manage templates on your own, you will need to know which merge fields are available. A merge field allows you to take data from the PMS and use them in emails.

 

Templates can be created and modified in Campaigns > Email Templates at https://emailmarketing.execu-tech.com/

 

 

When adding a merge field to your email template you must be very careful to get the syntax right.

For example, adding the guest name merge field must be done like this 

{GUESTNAME}

 

So, placing this in your email template might look something like this

<div>
Dear {GUESTNAME},<br><br>
Thank you for choosing to stay with us. Your reservation is booked, checking in on {CHECKINDATE} and checking out on {CHECKOUTDATE}.
</div>

 

If you want to include a merge field in a URL, you'll need to use the URL encoded version. To do this just add "URL_".

This is necessary because many characters used in names, dates, etc., are not valid in a URL. We "encode" them so that they're safe for the URL and still recognized by the destination. When you use the merge field {URL_PROFILENAME}, the name Smith, John, Jr. becomes Smith%2C%20John%2C%20Jr.

 

So, a link to a survey might look something like this

<a href="https://YourSurveyCompany/survey?name={URL_PROFILENAME}&account={URL_FOLIO}&arrive={URL_CHECKINDATE}&depart={URL_CHECKOUTDATE}">Take our survey</a>

 

 

This is a list of the available Merge Fields

 

 If you need to add a merge field to a URL (Like an HTML link), be sure to use the URL Encoded version by adding "URL_" to it.

{HOTELNAME} should be written as {URL_HOTELNAME} when placed in a URL.

 

HOTELNAME   The name from the Company Record. 
HOTELADDRESS1   Address line 1 from the Parameter Record.
HOTELADDRESS2 Address line 2 from the Parameter Record.
HOTELADDRESS3 Address line 2 from the Parameter Record.
GUESTNAME The guest name as it's typed. (SMITH, JOHN)
PROFILENAME The guest name normalized. (John Smith)
GUESTADDRESS The guest address line 1.
GUESTADDRESS2 The guest address line 2.
GUESTCITYST The guest City, State and ZIP.
GUESTCOMPANY The guest company.
GUESTCOMMENT The guest comment 1.
GUESTCOMMENT2 The guest comment 2.
GUESTCOMMENT3 The guest comment 3.
FOLIO The guest folio number.
ROOM The guest room number.
ROOMDESC The guest room description.
CHECKINDATE The guest check in date.
CHECKOUTDATE The guest check out date.
CHECKINTIME The guest check in time.
CHECKOUTTIME The guest check out time.
ADULTS The number of adults.
CHILD The number of children.

 

 

Microsoft Outlook Considerations

 

There are still many people using the desktop version of Microsoft Outlook. Because it uses the Microsoft Word rendering engine, emails that look beautiful everywhere else, including Outlook Web, can look bad on Outlook Desktop.

 

If you're working on a template and the results are unacceptable, you can paste your template into ChatGPT and ask it to format it for the desktop version of Microsoft Outlook.




Article ID
 email_marketing_merge_fields
Views
 12
Last Modified
 9/8/2025 4:27 PM