Adding and formatting merge fields in Microsoft Word
Here is a link to a 3 minute video showing an abbreviated summary of the content found in this document.
http://youtu.be/K7-5Ee91HF0
TIP: Appendix A is a handy reference when building templates, even if you already know how to use merge fields!
My Fundraising Place utilizes Microsoft Word® for email templates, custom flier templates, parent letters and (coming soon) the invoice templates.
My Fundraising Place passes numerical and date data into MS WORD as unformatted data, and the data formats must be applied within the MS WORD templates.
To add a merge field to a MS WORD Document, click on the insert field option found on the insert menu under the quick parts section.
Then the following window will appear, and after you select “MailMerge” from the field categories and “MergeField” from the field names, your screen will look like this:
Then you can add any of the available field names for the email template that you are trying to create (see appendix B of this document for a list of all field names). This example is showing you how to add the “DeliveryDate” field to a MS WORD template. Once you click “OK” the following field is inserted into the document.
If you right click on the merge field and select “Toggle Field Codes”
Or hit “ALT + F9” you will toggle the merge field to see the merge field format codes. This is what it looks like when no field format codes have been applied.
If you had data that was pushed into this delivery date field that was a date and time (such as: 04/07/2003), you could format the field several different ways (see appendix A for complete table of formatting options)
If you are formatting time, you can use the following formats:
If you are formatting other numbers, you can use the following formats:
For more information, refer to the following references:
http://www.officearticles.com/word/merge_field_formatting_in_microsoft_word.htm
http://support.softartisans.com/WordWriterV1/doc/features/format.asp
http://www.gmayor.com/formatting_word_fields.htm
Here is a link to a short video showing the insertion of a merge field and formatting the date.
http://youtu.be/K7-5Eif e91HF0
Appendix A – List of all merge fields
Merge Field Format |
Merge Field Name |
Data Type |
Notes |
Flier |
ContactName |
string |
|
Flier |
ContactNameLabel |
string |
|
Flier |
ContactPhone |
string |
|
Flier |
ContactPhoneLabel |
string |
|
Flier |
DealerCity |
string |
|
Flier |
DealerEmail |
string |
|
Flier |
DealerName |
string |
|
Flier |
DealerPhone |
string |
|
Flier |
DealerState |
string |
|
Flier |
DealerStreet1 |
string |
|
Flier |
DealerStreet2 |
string |
|
Flier |
DealerWebsite |
string |
|
Flier |
DealerZipcode |
string |
|
Flier |
DeliveryDate |
DateTime |
Same as DeliveryOn |
Flier |
DeliveryDateLabel |
string |
|
Flier |
DeliveryOn |
DateTime |
Format for DATE only! |
Flier |
FundsFor |
string |
|
Flier |
GroupGoal |
decimal |
|
Flier |
GroupName |
string |
|
Flier |
GroupNameLabel |
string |
|
Flier |
GroupProfitGoal |
decimal |
Called GroupGoal on flier |
Flier |
MakeChecksTo |
string |
|
Flier |
MinimumPerSeller |
int |
|
Flier |
Note1 |
string |
|
Flier |
Note2 |
string |
|
Flier |
Note3 |
string |
|
Flier |
P01CP |
decimal |
|
Flier |
P01DN |
string |
|
Flier |
P01NM |
string |
|
Flier |
P02CP |
decimal |
|
Flier |
P02DN |
string |
|
Flier |
P02NM |
string |
|
Flier |
P03CP |
decimal |
|
Flier |
P03DN |
string |
|
Flier |
P03NM |
string |
|
Flier |
P04CP |
decimal |
|
Flier |
P04DN |
string |
|
Flier |
P04NM |
string |
|
Flier |
P05CP |
decimal |
|
Flier |
P05DN |
string |
|
Flier |
P05NM |
string |
|
Flier |
P06CP |
decimal |
|
Flier |
P06DN |
string |
|
Flier |
P06NM |
string |
|
Flier |
P07CP |
decimal |
|
Flier |
P07DN |
string |
|
Flier |
P07NM |
string |
|
Flier |
P08CP |
decimal |
|
Flier |
P08DN |
string |
|
Flier |
P08NM |
string |
|
Flier |
P09CP |
decimal |
|
Flier |
P09DN |
string |
|
Flier |
P09NM |
string |
|
Flier |
P10CP |
decimal |
|
Flier |
P10DN |
string |
|
Flier |
P10NM |
string |
|
Flier |
P11CP |
decimal |
|
Flier |
P11DN |
string |
|
Flier |
P11NM |
string |
|
Flier |
P12CP |
decimal |
|
Flier |
P12DN |
string |
|
Flier |
P12NM |
string |
|
Flier |
P13CP |
decimal |
|
Flier |
P13DN |
string |
|
Flier |
P13NM |
string |
|
Flier |
P14CP |
decimal |
|
Flier |
P14DN |
string |
|
Flier |
P14NM |
string |
|
Flier |
P15CP |
decimal |
|
Flier |
P15DN |
string |
|
Flier |
P15NM |
string |
|
Flier |
P16CP |
decimal |
|
Flier |
P16DN |
string |
|
Flier |
P16NM |
string |
|
Flier |
P17CP |
decimal |
|
Flier |
P17DN |
string |
|
Flier |
P17NM |
string |
|
Flier |
P18CP |
decimal |
|
Flier |
P18DN |
string |
|
Flier |
P18NM |
string |
|
Flier |
P19CP |
decimal |
|
Flier |
P19DN |
string |
|
Flier |
P19NM |
string |
|
Flier |
P20CP |
decimal |
|
Flier |
P20DN |
string |
|
Flier |
P20NM |
string |
|
Flier |
P21CP |
decimal |
|
Flier |
P21DN |
string |
|
Flier |
P21NM |
string |
|
Flier |
P22CP |
decimal |
|
Flier |
P22DN |
string |
|
Flier |
P22NM |
string |
|
Flier |
P23CP |
decimal |
|
Flier |
P23DN |
string |
|
Flier |
P23NM |
string |
|
Flier |
P24CP |
decimal |
|
Flier |
P24DN |
string |
|
Flier |
P24NM |
string |
|
Flier |
P25CP |
decimal |
|
Flier |
P25DN |
string |
|
Flier |
P25NM |
string |
|
Flier |
ReturnOrderOn |
DateTime |
Format for DATE only! |
Invoice |
AmountCollectedOnline |
decimal |
|
Invoice |
BillToAddress |
string |
|
Invoice |
BillToContactFirstName |
string |
|
Invoice |
BillToContactLastName |
string |
|
Invoice |
BillToContactName |
string |
|
Invoice |
BillToGroupName |
string |
|
Invoice |
BillToPhone |
string |
|
Invoice |
DealerAddress |
string |
|
Invoice |
DealerEmail |
string |
|
Invoice |
DealerLogo |
image |
|
Invoice |
DealerName |
string |
|
Invoice |
DealerWebsite |
string |
|
Invoice |
DeliveredOn |
DateTime |
|
Invoice |
Delivery |
decimal |
|
Invoice |
DeliveryArriveAt |
DateTime |
|
Invoice |
DeliveryArriveAtFormatted |
string |
|
Invoice |
DeliveryArriveOn |
DateTime |
|
Invoice |
DeliveryDate |
DateTime |
|
Invoice |
DeliveryPickupEnd |
DateTime |
|
Invoice |
DeliveryPickUpFormatted |
string |
|
Invoice |
DeliveryPickupStart |
DateTime |
|
Invoice |
DetailTotal |
decimal |
|
Invoice |
Discount |
decimal |
|
Invoice |
FundraiserName |
string |
|
Invoice |
InvoiceDate |
DateTime |
|
Invoice |
InvoiceNumber |
string |
|
Invoice |
Notes |
string |
|
Invoice |
Profit |
decimal |
|
Invoice |
ProfitPercentage |
decimal |
|
Invoice |
QuantityTotal |
int |
|
Invoice |
RevisionNumber |
int |
|
Invoice |
ShipToAddress |
string |
|
Invoice |
ShipToContactFirstName |
string |
|
Invoice |
ShipToContactLastName |
string |
|
Invoice |
ShipToContactName |
string |
|
Invoice |
ShipToGroupName |
string |
|
Invoice |
ShipToPhone |
string |
|
Invoice |
Subtotal |
decimal |
|
Invoice |
Tax |
decimal |
|
Invoice |
TotalDue |
decimal |
|
Invoice Details |
Cases |
int |
|
Invoice Details |
DisplayOrder |
int |
|
Invoice Details |
Eaches |
int |
|
Invoice Details |
ProductLineName |
string |
|
Invoice Details |
ProductName |
string |
|
Invoice Details |
ProductNumber |
string |
|
Invoice Details |
Quantity |
int |
|
Invoice Details |
TotalUnitPrice |
decimal |
|
Invoice Details |
UnitPrice |
decimal |
|
Label |
Box «X» of «N |
string |
|
Label |
CurrentLabelCount |
decimal |
|
Label |
CustomField1 |
string |
|
Label |
CustomField2 |
string |
|
Label |
CustomField3 |
string |
|
Label |
DeliveryDate |
DateTime |
|
Label |
LabelCount |
decimal |
|
Label |
LastPrintedDate |
DateTime |
|
Label |
Organization |
string |
|
Label |
P01Nm |
string |
|
Label |
P01Qty |
int |
|
Label |
P01SNm |
string |
|
Label |
P02Nm |
string |
|
Label |
P02Qty |
int |
|
Label |
P02SNm |
string |
|
Label |
P03Nm |
string |
|
Label |
P03Qty |
int |
|
Label |
P03SNm |
string |
|
Label |
P04Nm |
string |
|
Label |
P04Qty |
int |
|
Label |
P04SNm |
string |
|
Label |
P05Nm |
string |
|
Label |
P05Qty |
int |
|
Label |
P05SNm |
string |
|
Label |
P06Nm |
string |
|
Label |
P06Qty |
int |
|
Label |
P06SNm |
string |
|
Label |
P07Nm |
string |
|
Label |
P07Qty |
int |
|
Label |
P07SNm |
string |
|
Label |
P08Nm |
string |
|
Label |
P08Qty |
int |
|
Label |
P08SNm |
string |
|
Label |
P09Nm |
string |
|
Label |
P09Qty |
int |
|
Label |
P09SNm |
string |
|
Label |
P10Nm |
string |
|
Label |
P10Qty |
int |
|
Label |
P10SNm |
string |
|
Label |
P11Nm |
string |
|
Label |
P11Qty |
int |
|
Label |
P11SNm |
string |
|
Label |
P12Nm |
string |
|
Label |
P12Qty |
int |
|
Label |
P12SNm |
string |
|
Label |
P13Nm |
string |
|
Label |
P13Qty |
int |
|
Label |
P13SNm |
string |
|
Label |
P14Nm |
string |
|
Label |
P14Qty |
int |
|
Label |
P14SNm |
string |
|
Label |
P15Nm |
string |
|
Label |
P15Qty |
int |
|
Label |
P15SNm |
string |
|
Label |
P16Nm |
string |
|
Label |
P16Qty |
int |
|
Label |
P16SNm |
string |
|
Label |
P17Nm |
string |
|
Label |
P17Qty |
int |
|
Label |
P17SNm |
string |
|
Label |
P18Nm |
string |
|
Label |
P18Qty |
int |
|
Label |
P18SNm |
string |
|
Label |
P19Nm |
string |
|
Label |
P19Qty |
int |
|
Label |
P19SNm |
string |
|
Label |
P20Nm |
string |
|
Label |
P20Qty |
int |
|
Label |
P20SNm |
string |
|
Label |
P21Nm |
string |
|
Label |
P21Qty |
int |
|
Label |
P21SNm |
string |
|
Label |
P22Nm |
string |
|
Label |
P22Qty |
int |
|
Label |
P22SNm |
string |
|
Label |
P23Nm |
string |
|
Label |
P23Qty |
int |
|
Label |
P23SNm |
string |
|
Label |
P24Nm |
string |
|
Label |
P24Qty |
int |
|
Label |
P24SNm |
string |
|
Label |
P25Nm |
string |
|
Label |
P25Qty |
int |
|
Label |
P25SNm |
string |
|
Label |
P26Nm |
string |
|
Label |
P26Qty |
int |
|
Label |
P26SNm |
string |
|
Label |
P27Nm |
string |
|
Label |
P27Qty |
int |
|
Label |
P27SNm |
string |
|
Label |
P28Nm |
string |
|
Label |
P28Qty |
int |
|
Label |
P28SNm |
string |
|
Label |
P29Nm |
string |
|
Label |
P29Qty |
int |
|
Label |
P29SNm |
string |
|
Label |
P30Nm |
string |
|
Label |
P30Qty |
int |
|
Label |
P30SNm |
string |
|
Label |
P31Nm |
string |
|
Label |
P31Qty |
int |
|
Label |
P31SNm |
string |
|
Label |
P32Nm |
string |
|
Label |
P32Qty |
int |
|
Label |
P32SNm |
string |
|
Label |
P33Nm |
string |
|
Label |
P33Qty |
int |
|
Label |
P33SNm |
string |
|
Label |
P34Nm |
string |
|
Label |
P34Qty |
int |
|
Label |
P34SNm |
string |
|
Label |
P35Nm |
string |
|
Label |
P35Qty |
int |
|
Label |
P35SNm |
string |
|
Label |
SellerCustomField |
string |
|
Label |
SellerFirstName |
string |
|
Label |
SellerLastName |
string |
|
Label |
SellerNumber |
int |
|
Label |
TotalItems |
int |
|
Marketing Email |
ContactAddressName |
string |
|
Marketing Email |
ContactCity |
string |
|
Marketing Email |
ContactEmail |
string |
|
Marketing Email |
ContactFirstName |
string |
|
Marketing Email |
ContactLastName |
string |
|
Marketing Email |
ContactPhoneExtString |
string |
|
Marketing Email |
ContactPhoneString |
string |
|
Marketing Email |
ContactState |
string |
|
Marketing Email |
ContactStreet1 |
string |
|
Marketing Email |
ContactStreet2 |
string |
|
Marketing Email |
ContactZipCode |
string |
|
Marketing Email |
DealerCity |
string |
|
Marketing Email |
DealerEmail |
string |
|
Marketing Email |
DealerName |
string |
|
Marketing Email |
DealerPhoneExtString |
string |
|
Marketing Email |
DealerPhoneString |
string |
|
Marketing Email |
DealerState |
string |
|
Marketing Email |
DealerStreet1 |
string |
|
Marketing Email |
DealerStreet2 |
string |
|
Marketing Email |
DealerWebsite |
string |
|
Marketing Email |
DealerZipCode |
string |
|
Marketing Email |
GroupAddressName |
string |
|
Marketing Email |
GroupCity |
string |
|
Marketing Email |
GroupEmail |
string |
|
Marketing Email |
GroupName |
string |
|
Marketing Email |
GroupPhoneExtString |
string |
|
Marketing Email |
GroupPhoneString |
string |
|
Marketing Email |
GroupState |
string |
|
Marketing Email |
GroupStreet1 |
string |
|
Marketing Email |
GroupStreet2 |
string |
|
Marketing Email |
GroupZipCode |
string |
|
Marketing Email |
SalesPersonEmail |
string |
|
Marketing Email |
SalesPersonFirstName |
string |
|
Marketing Email |
SalesPersonLastName |
string |
|
Marketing Email |
SalesPersonPhoneExtString |
string |
|
Marketing Email |
SalesPersonPhoneString |
string |
|
Touchpoint Email |
ArriveAtTBD |
bool |
|
Touchpoint Email |
CallInOrderOn |
DateTime |
Format for DATE only! |
Touchpoint Email |
ContactAddressCity |
string |
|
Touchpoint Email |
ContactAddressName |
string |
|
Touchpoint Email |
ContactAddressState |
string |
|
Touchpoint Email |
ContactAddressStreet1 |
string |
|
Touchpoint Email |
ContactAddressStreet2 |
string |
|
Touchpoint Email |
ContactAddressZipCode |
string |
|
Touchpoint Email |
ContactCity |
string |
|
Touchpoint Email |
ContactEmail |
string |
|
Touchpoint Email |
ContactFirstName |
string |
|
Touchpoint Email |
ContactLastName |
string |
|
Touchpoint Email |
ContactName |
string |
|
Touchpoint Email |
ContactNameFormatted |
string |
|
Touchpoint Email |
ContactPhone |
long |
|
Touchpoint Email |
ContactPhoneExt |
int |
|
Touchpoint Email |
ContactPhoneExtString |
string |
|
Touchpoint Email |
ContactPhoneString |
string |
|
Touchpoint Email |
ContactState |
string |
|
Touchpoint Email |
ContactStreet1 |
string |
|
Touchpoint Email |
ContactStreet2 |
string |
|
Touchpoint Email |
ContactZipCode |
string |
|
Touchpoint Email |
CustomField3 |
string |
|
Touchpoint Email |
CustomField4 |
string |
|
Touchpoint Email |
CustomLabel3 |
string |
|
Touchpoint Email |
CustomLabel4 |
string |
|
Touchpoint Email |
DaysLeftToSell |
int |
|
Touchpoint Email |
DealerAddressFormatted |
string |
|
Touchpoint Email |
DealerCity |
string |
|
Touchpoint Email |
DealerEmail |
string |
|
Touchpoint Email |
DealerName |
string |
|
Touchpoint Email |
DealerPhone |
long |
|
Touchpoint Email |
DealerPhoneExt |
int |
|
Touchpoint Email |
DealerPhoneExtString |
string |
|
Touchpoint Email |
DealerPhoneFormatted |
string |
|
Touchpoint Email |
DealerPhoneString |
string |
|
Touchpoint Email |
DealerState |
string |
|
Touchpoint Email |
DealerStreet1 |
string |
|
Touchpoint Email |
DealerStreet2 |
string |
|
Touchpoint Email |
DealerWebsite |
string |
|
Touchpoint Email |
DealerZipCode |
string |
|
Touchpoint Email |
DeliveryAddressFormatted |
string |
|
Touchpoint Email |
DeliveryAddressName |
string |
|
Touchpoint Email |
DeliveryCity |
string |
|
Touchpoint Email |
DeliveryEndAt |
DateTime |
Format for TIME only! |
Touchpoint Email |
DeliveryEndAtFormatted |
string |
|
Touchpoint Email |
DeliveryExtItems |
string |
|
Touchpoint Email |
DeliveryMinimum |
int |
|
Touchpoint Email |
DeliveryOn |
DateTime |
Format for DATE only! |
Touchpoint Email |
DeliveryOnFormatted |
string |
|
Touchpoint Email |
DeliveryOwnerFirstName |
string |
|
Touchpoint Email |
DeliveryOwnerLastName |
string |
|
Touchpoint Email |
DeliveryOwnerPhone |
long |
|
Touchpoint Email |
DeliveryOwnerPhoneString |
string |
|
Touchpoint Email |
DeliveryPickupAt |
DateTime |
Format for TIME only! |
Touchpoint Email |
DeliveryPickupAtFormatted |
string |
|
Touchpoint Email |
DeliveryPickupEndAt |
DateTime |
Format for TIME only! |
Touchpoint Email |
DeliveryPickupEndAtFormatted |
string |
|
Touchpoint Email |
DeliveryStartAt |
DateTime |
Format for TIME only! |
Touchpoint Email |
DeliveryStartAtFormatted |
string |
|
Touchpoint Email |
DeliveryState |
string |
|
Touchpoint Email |
DeliveryStreet1 |
string |
|
Touchpoint Email |
DeliveryStreet2 |
string |
|
Touchpoint Email |
DeliveryUnits |
string |
|
Touchpoint Email |
DeliveryZipCode |
string |
|
Touchpoint Email |
EndAtTBD |
bool |
|
Touchpoint Email |
EndOn |
DateTime |
This is the Return Order Date |
Touchpoint Email |
EndOnTBD |
bool |
|
Touchpoint Email |
FlierNote1 |
string |
|
Touchpoint Email |
FlierNote2 |
string |
|
Touchpoint Email |
FlierNote3 |
string |
|
Touchpoint Email |
Fliers |
int |
|
Touchpoint Email |
FundraiserName |
string |
|
Touchpoint Email |
FundraiserYear |
int |
|
Touchpoint Email |
FundsFor |
string |
|
Touchpoint Email |
GroupAddressCity |
string |
|
Touchpoint Email |
GroupAddressName |
string |
|
Touchpoint Email |
GroupAddressState |
string |
|
Touchpoint Email |
GroupAddressStreet1 |
string |
|
Touchpoint Email |
GroupAddressStreet2 |
string |
|
Touchpoint Email |
GroupAddressZipCode |
string |
|
Touchpoint Email |
GroupCity |
string |
|
Touchpoint Email |
GroupEmail |
string |
|
Touchpoint Email |
GroupGoal |
decimal |
|
Touchpoint Email |
GroupIncentive |
string |
|
Touchpoint Email |
GroupName |
string |
|
Touchpoint Email |
GroupParticipation |
decimal |
Formatted as xx.x |
Touchpoint Email |
GroupPhone |
long |
|
Touchpoint Email |
GroupPhoneExt |
int |
|
Touchpoint Email |
GroupPhoneExtString |
string |
|
Touchpoint Email |
GroupPhoneString |
string |
|
Touchpoint Email |
GroupPortalURL |
string |
|
Touchpoint Email |
GroupProfit |
decimal |
|
Touchpoint Email |
GroupProfitGoal |
decimal |
|
Touchpoint Email |
GroupSize |
int |
|
Touchpoint Email |
GroupState |
string |
|
Touchpoint Email |
GroupStreet1 |
string |
|
Touchpoint Email |
GroupStreet2 |
string |
|
Touchpoint Email |
GroupZipCode |
string |
|
Touchpoint Email |
IncentiveDescription |
string |
|
Touchpoint Email |
IsPrePack |
bool |
“True” if checked |
Touchpoint Email |
KickOffAddressName |
string |
|
Touchpoint Email |
KickOffAt |
DateTime |
Format for TIME only! |
Touchpoint Email |
KickOffAtFormatted |
string |
|
Touchpoint Email |
KickOffCity |
string |
|
Touchpoint Email |
KickOffOn |
DateTime |
Format for DATE only! |
Touchpoint Email |
KickOffState |
string |
|
Touchpoint Email |
KickOffStreet1 |
string |
|
Touchpoint Email |
KickOffStreet2 |
string |
|
Touchpoint Email |
KickOffZipCode |
string |
|
Touchpoint Email |
LeaveAtTBD |
bool |
|
Touchpoint Email |
MakeChecksTo |
string |
|
Touchpoint Email |
MinimumPerSeller |
int |
|
Touchpoint Email |
PFAddressName |
string |
|
Touchpoint Email |
PFCity |
string |
|
Touchpoint Email |
PFState |
string |
|
Touchpoint Email |
PFStreet1 |
string |
|
Touchpoint Email |
PFStreet2 |
string |
|
Touchpoint Email |
PFZipCode |
string |
|
Touchpoint Email |
Posters |
int |
|
Touchpoint Email |
PriceListDisplayName |
string |
|
Touchpoint Email |
PriceListName |
string |
|
Touchpoint Email |
PrintFlierAddressName |
string |
|
Touchpoint Email |
PrintFlierCity |
string |
|
Touchpoint Email |
PrintFliersOn |
DateTime |
Format for DATE only! |
Touchpoint Email |
PrintFlierState |
string |
|
Touchpoint Email |
PrintFlierStreet1 |
string |
|
Touchpoint Email |
PrintFlierStreet2 |
string |
|
Touchpoint Email |
PrintFlierZipCode |
string |
|
Touchpoint Email |
ProgramDescription |
string |
|
Touchpoint Email |
ReturnOrderOn |
DateTime |
Format for DATE only! |
Touchpoint Email |
SalesPersonFirstName |
string |
|
Touchpoint Email |
SalesPersonLastName |
string |
|
Touchpoint Email |
SalesPersonNameFormatted |
string |
|
Touchpoint Email |
SalesPersonPhone |
long |
|
Touchpoint Email |
SalesPersonPhoneExt |
int |
|
Touchpoint Email |
SalesPersonPhoneExtString |
string |
|
Touchpoint Email |
SalesPersonPhoneFormatted |
string |
|
Touchpoint Email |
SalesPersonPhoneString |
string |
|
Touchpoint Email |
SendStartupKitOn |
DateTime |
|
Touchpoint Email |
SignupURL |
string |
|
Touchpoint Email |
StartAtTBD |
bool |
|
Touchpoint Email |
StartOn |
DateTime |
Format for DATE only! |
Touchpoint Email |
StartOnTBD |
bool |
|
Touchpoint Email |
StoreURL |
string |
|
Touchpoint Email |
TimeZone |
string |
|
Touchpoint Email |
TimeZoneAbbreviation |
string |
|
Touchpoint Email |
TotalExtItems |
int |
|
Touchpoint Email |
TotalUnits |
int |
|