• Help
  • Community
  • Templates
  • Webinars
  • Help
  • Community
  • Templates
  • Webinars

Settings

home/Knowledge Base/Settings
Try:Getting Started, Create a Contact, QuickBooks

Adding and formatting merge fields in Microsoft Word

2893 views April 4, 2019 May 6, 2019 Jordan Knapp 2

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

 

Attached Files
# File Type File Size Download
1 .xlsx 27.36 KB My Fundraising Place Merge Fields List
2 .docx 19.73 KB Custom Invoice Merge Fields Reference Sheet
3 .docx 43.79 KB Flier Merge Fields Reference Sheet
4 .docx 35.46 KB Marketing Emails Merge Fields Reference Sheet
5 .docx 45.06 KB PrePack Label Merge Fields Reference Sheet
6 .docx 46.88 KB Touchpoint Emails Merge Fields Reference Sheet

Was this helpful?

2 Yes 2 No
Related Articles
  • How to copy the GLP or MFP link
  • How to copy the Signup Link
  • How to not Sync Sales Tax from My Fundraising Place to QuickBooks
  • Formatting Merge Fields in Templates
  • Tips & Tricks in My Fundraising Place
  • Create a new Product

Settings
  • Adding and formatting merge fields in Microsoft Word
  • How to copy the GLP or MFP link
  • How to copy the Signup Link
  • How to not Sync Sales Tax from My Fundraising Place to QuickBooks
  • Formatting Merge Fields in Templates
View All 17
Popular Articles
  • Printing Labels
  • Marketing Lists Walk-through
  • Setting up Touch Points
  • Creating a fundraiser
  • Sales Cadence Process
Categories
  • Finance
  • Getting Started
  • Marketing
  • Operations
  • Sales
  • Settings
  • © My Fundraising Place | All Rights Reserved
    213 4th Avenue Northeast West Bend, IA 50597