|
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, wrapping the merge field in braces { }
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
|
|
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.
|
| |
Merge fields will be different between pre and post stay letters, with a few that overlap. For example, a guest who hasn't checked in doesn't have a Folio Number yet.
|
| Merge Field |
Type |
Description |
| HOTELNAME |
Post |
The name from the Company Record. |
| HOTELADDRESS1 |
Post |
Address line 1 from the Parameter Record. |
| HOTELADDRESS2 |
Post |
Address line 2 from the Parameter Record. |
| HOTELADDRESS3 |
Post |
Address line 2 from the Parameter Record. |
| GUESTNAME |
Post |
The guest name as it's typed. (SMITH, JOHN) |
| PROFILENAME |
Post |
The guest name normalized. (John Smith) |
| GUESTADDRESS |
Post |
The guest address line 1. |
| GUESTADDRESS2 |
Post |
The guest address line 2. |
| GUESTCITYST |
Post |
The guest City, State and ZIP. |
| GUESTCOMPANY |
Post |
The guest company. |
| GUESTCOMMENT |
Both |
The guest comment 1. |
| GUESTCOMMENT2 |
Both |
The guest comment 2. |
| GUESTCOMMENT3 |
Both |
The guest comment 3. |
| FOLIO |
Post |
The guest folio number. |
| ROOM |
Post |
The guest room number. |
| ROOMDESC |
Post |
The guest room description. |
| CHECKINDATE |
Post |
The guest check in date. |
| CHECKOUTDATE |
Post |
The guest check out date. |
| CHECKINTIME |
Post |
The guest check in time. |
| CHECKOUTTIME |
Post |
The guest check out time. |
| ADULTS |
Post |
The number of adults. |
| CHILD |
Post |
The number of children. |
| FIRSTNIGHTROOMTAX |
Pre |
This is the first night room and tax. |
| TOTALROOMTAX |
Pre |
This is the total room and tax. |
| TOTALROOMONLY |
Pre |
This is the total room only, no tax included. |
| NETDUE |
Pre |
This is the net due, minus any deposits. |
| RESNAME |
Pre |
This is the name on the reservation. |
| RESNAME-CAPS |
Pre |
This is the name on the reservation in all capital letters. |
| GUARCOMM |
Pre |
This is the guarantee comment (Guaranteed, Not Guaranteed) |
| GUARTYPE |
Pre |
This is the guarantee type (CA, AX, VS, etc.) |
| RESNO |
Both |
This is the conformation number. |
| CANCNO |
Pre |
This is the cancellation number. |
|
| |
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.
|
|