Cover Page, Literature, and Microsoft Word Template Document Macros

The following macros are examples of the fields that can be used in the cover page, literature documents, and/or MS Word templates to pull the related information from QuoteWerks into the documents. This is not a complete list, full table information of the fields available can be found at DocumentHeaders Tables & Fields and DocumentItems Tables & Fields

Note: When the macros are placed in RTF cover pages, they must be double-underlined. You can double-underline text when specifying the font for the text. For Word documents, they need to have open and closed angle brackets (e.g. <<&DH_DocNo>>).

&DH_AlternateCommissionAmount

&DH_&AlternateCurrencyIdentifier

&DH_&AlternateCurrencySymbol

&DH_AlternateDepositAmount

&DI_AlternateExtendedPrice

&DH_AlternateGrandTotal

&DH_AlternateGSTTax

&DH_AlternateLocalTax

&DH_AlternateProfitAmount

&DH_AlternateShippingAmount

&DH_AlternateSubTotal

&DH_&AlternateTotalCost

&DH_&AlternateTotalList

&DH_AlternateTotalTax

&DH_SoldToCompany

&DH_SoldToContact

&DH_&SoldToFirstName

&DH_&SoldToLastName

&DH_SoldToTitle

&DH_SoldToAddress1

&DH_SoldToAddress2

&DH_SoldToAddress3

&DH_SoldToCity

&DH_SoldToState

&DH_SoldToPostalCode

&DH_SoldToCountry

&DH_&SoldToAddress

&DH_&SoldToFullAddress

&DH_&SoldToInLineAddress

&DH_SoldToMobile

&DH_SoldToPhoneExt

&DH_SoldToPhone

&DH_SoldToFaxExt

&DH_SoldToFax

&DH_SoldToEMail

&DH_SoldToPONumber

&DH_ShipToCompany

&DH_ShipToContact

&DH_&ShipToFirstName

&DH_&ShipToLastName

&DH_ShipToMobile

&DH_ShipToTitle

&DH_ShipToAddress1

&DH_ShipToAddress2

&DH_ShipToAddress3

&DH_ShipToCity

&DH_ShipToState

&DH_ShipToPostalCode

&DH_ShipToCountry

&DH_&ShipToAddress

&DH_&ShipToFullAddress

&DH_&ShipToInLineAddress

&DH_ShipToPhoneExt

&DH_ShipToPhone

&DH_ShipToFaxExt

&DH_ShipToFax

&DH_ShipToEMail

&DH_BillToCompany

&DH_BillToContact

&DH_&BillToFirstName

&DH_&BillToLastName

&DH_BillToTitle

&DH_BillToAddress1

&DH_BillToAddress2

&DH_BillToAddress3

&DH_BillToCity

&DH_BillToState

&DH_BillToPostalCode

&DH_BillToCountry

&DH_&BillToAddress

&DH_&BillToFullAddress

&DH_&BillToInlineAddress

&DH_BillToMobile

&DH_BillToPhoneExt

&DH_BillToPhone

&DH_BillToFaxExt

&DH_BillToFax

&DH_BillToEMail

&DH_IntroductionNotes

&DH_ClosingNotes

&DH_InternalNotes

&DH_PurchasingNotes

&DH_&SalesRepFullName

&DH_&SalesRepAddress

&DH_&SalesRepFullAddress

&DH_&SalesRepFullAddressA

&DH_&SalesRepAddress1

&DH_&SalesRepAddress2

&DH_&SalesRepAddress3

&DH_&SalesRepCity

&DH_&SalesRepMobilePhone

&DH_&SalesRepState

&DH_&SalesRepPostalCode

&DH_&SalesRepCountry

&DH_&SalesRepPhone

&DH_&SalesRepPhoneExt
&DH_&SalesRepPhoneExtA

&DH_&SalesRepFax
&DH_&SalesRepFaxA

&DH_FOB

&DH_ShipVia

&DH_Terms

&DH_ContractStartDate

&DH_ContractEndDate

&DH_CustomText01

&DH_CustomText02

&DH_CustomText03

&DH_CustomText04

&DH_CustomText05

&DH_CustomText06

&DH_CustomText07

&DH_CustomText08

&DH_CustomText09

&DH_CustomText10

&DH_CustomText11

&DH_CustomText12

&DH_CustomText13

&DH_CustomText14

&DH_CustomText15

&DH_CustomText16

&DH_CustomText17

&DH_CustomText18

&DH_CustomText19

&DH_CustomText20

&DH_CustomDate01

&DH_CustomDate02

&DH_CustomNumber01

&DH_CustomNumber02

&DH_&SalesRepFaxExt

&DH_&SalesRepTitle

&DH_&SalesRepEmail

&DH_&SalesRepFullNameOrUserName

&DH_&SalesRepInlineAddress

&DH_&SalesRepMobilePhone

&DH_SalesRep

&DH_&SalesRepFullName

&DH_DocNo

&DH_ProjectNo

&DH_DocName

&DH_DocType

&DH_DocStatus

&DH_DocDate

&DH_DocDueDate

&DH_ExpirationDate

&DH_GrandTotal

&DH_&TotalCost

&DH_&TotalList

&DH_SubTotal

&DH_TotalTax

&DH_LocalTax

&DH_LocalTaxRate

&DH_GSTTax

&DH_ShippingAmount

&DH_CommissionAmount

&DH_&PaymentOptions

&DH_&PaymentOptions_IndicateSelected

&DH_ProfitAmount

&DH_&ProfitPercent

&DH_&PreparedByAddress

&DH_&PreparedByAddress1

&DH_&PreparedByAddress2

&DH_&PreparedByAddress3

&DH_&PreparedByCity

&DH_&PreparedByCountry

&DH_&PreparedByEmail

&DH_&PreparedByFax

&DH_&PreparedByFaxA

&DH_&PreparedByFaxExt

&DH_&PreparedByFullAddress

&DH_&PreparedByFullAddressA

&DH_&PreparedByInlineAddress

&DH_&PreparedByFullNameOrUserName

&DH_&PreparedByFullName

&DH_&PreparedByPhone

&DH_&PreparedByPhoneExt

&DH_&PreparedByPhoneWithExt

&DH_&PreparedByPhoneWithExtA

&DH_&PreparedByMobilePhone

&DH_&PreparedByPostalCode

&DH_&PreparedByByState

&DH_&PreparedByTitle

&DH_&PreparedByPicture

&DH_&PreparedByElectronicSignature

&DH_&PreparedByAddress

&DH_&QuoteValetTotalPaymentsMade

&DH_&FirstName

&DH_&LastName

&DH_LastModified_Date

&DH_LastModified_Time

&DH_&QuoteValetCustomerFacingURL

&DH_&QuoteValetPeerReviewURL

&DH_&QuoteValetApprovalURL

&DH_&URLToOpenDocument

&DI_&Line1ManufacturerPartNumber

&DI_&Line1VendorPartNumber

&DI_&Line1Description

&DI_&LineItemCount

&SYS_InstallPath

&SYS_ExecPath

&SYS_DataPath

&SYS_AppVersion, &SYS_AppBuildNumber

&SYS_AppEdition

&SYS_BackendDBType

&SYS_InstallUniqueID

&SYS_NowA

&SYS_NowB

&APP_CustomMessage1

&APP_CustomMessage2

&APP_LicenseeCompany

&APP_LicenseeContact

&APP_LicenseeAddress1

&APP_LicenseeAddress2

&APP_LicenseeAddress3

&APP_LicenseePhone

&APP_LicenseePhoneExt

&APP_LicenseeFax

&APP_LicenseeFaxExt

&APP_LicenseeEmail

&APP_&LicenseeInlineAddress

&APP_&LoggedInUserAddress

&APP_&LoggedInUserFullAddress

&APP_&LoggedInUserFullAddressA

&APP_LoggedInUserAddress1

&APP_LoggedInUserAddress2

&APP_LoggedInUserAddress3

&APP_LoggedInUserCustomText01

&APP_LoggedInUserCustomText02

&APP_LoggedInUserCity

&APP_LoggedInUserState

&APP_LoggedInUserPostalCode

&APP_LoggedInUserCountry

&APP_LoggedInUserName

&APP_LoggedInUserFullName

&APP_&LoggedInUserFullNameOrUserName

&APP_&LoggedInUserInlineAddress

&APP_LoggedInUserTitle

&APP_LoggedInUserPhone

&APP_LoggedInUserPhoneExt

&APP_&LoggedInUserPhoneWithExt

&APP_&LoggedInUserPhoneWithExtA

&APP_LoggedInUserFax

&APP_LoggedInUserFaxA

&APP_LoggedInUserFaxExt

&APP_LoggedInUserEmail

&APP_LoggedInUserMobilePhone

&APP_OurLocationCompany

&APP_OurLocationContact

&APP_&OurLocationAddress

&APP_&OurLocationFullAddress

&APP_OurLocationAddress1

&APP_OurLocationAddress2

&APP_OurLocationAddress3

&APP_OurLocationCity

&APP_OurLocationState

&APP_OurLocationPostalCode

&APP_OurLocationCountry

&APP_OurLocationPhoneNumber

&APP_OurLocationPhoneExt

&APP_OurLocationFaxNumber

&APP_OurLocationFaxExt

&APP_OurLocationEmail

&APP_&LoggedInUserFullNameOrUserName

&APP_&LicenseeWebsite

&COVER_RE

&COVER_Message

&SYS_NowA

&SYS_NowB

&SYS_TodaysDate

&SYS_TodaysDateA

&SYS_TodaysDateForSQL

&SYS_FirstDayOfThisWeekForSQL

&SYS_FirstDayOfLastWeekForSQL

&SYS_FirstDayofCurrentMonthForSQL

&SYS_FirstDayofNextMonthForSQL

&SYS_FirstDayofLastMonthForSQL

&SYS_YesterdaysDateForSQL

&SYS_30DaysAgoForSQL

&SYS_45DaysAgoForSQL

&SYS_60DaysAgoForSQL

&SYS_90DaysAgoForSQL

Macros for Only Microsoft Word Templates

These macros are only used in Microsoft Word Documents and will not work in RTF Cover Pages, Literature, or Spec Sheet :

Document Headers: Document Items:

&DH_&AlternateCurrencyIdentifier

&DH_&AlternateCurrencySymbol

&DH_&AlternateTotalCost

&DH_&AlternateTotalList

&DH_&BillToAddress

&DH_&BillToFullAddress

&DH_&BillToInlineAddress

&DH_&GSTTaxableAmount

&DH_&PaymentOptions

&DH_&PaymentOptions_IndicateSelected

&DH_&PreparedByAddress

&DH_&PreparedByAddress1

&DH_&PreparedByAddress2

&DH_&PreparedByAddress3

&DH_&PreparedByCity

&DH_&PreparedByCountry

&DH_&PreparedByElectronicSignature

&DH_&PreparedByEMail

&DH_&PreparedByFax

&DH_&PreparedByFaxA

&DH_&PreparedByFaxExt

&DH_&PreparedByFullAddress

&DH_&PreparedByFullAddressA

&DH_&PreparedByFullName

&DH_&PreparedByFullNameOrUserName

&DH_&PreparedByInlineAddress

&DH_&PreparedByMobilePhone

&DH_&PreparedByPhone

&DH_&PreparedByPhoneExt

&DH_&PreparedByPhoneWithExt

&DH_&PreparedByPhoneWithExtA

&DH_&PreparedByPicture

&DH_&PreparedByPostalCode

&DH_&PreparedByState

&DH_&PreparedByTitle

&DH_&ProfitPercent

&DH_&PSTTaxableAmount

&DH_&RecurringRevenueAnnualSubtotal

&DH_&RecurringRevenueAnnualSubtotalWithTax

&DH_&RecurringRevenueMonthlySubtotal

&DH_&RecurringRevenueMonthlySubtotalWithTax

&DH_&RecurringRevenueQuarterlySubtotal

&DH_&RecurringRevenueQuarterlySubtotalWithTax

&DH_&RecurringRevenueWeeklySubtotal

&DH_&RecurringRevenueWeeklySubtotalWithTax

&DI_&QtyGroupMemberTotal_Actual

&DI_&QTYTOTAL_ACTUAL

&DI_&QTYGROUPMULTIPLIER_ACTUAL

&DI_&ProfitAmount

&DI_&RecurringRevenueAnnual

&DI_&RecurringRevenueAnnualWithTax

&DI_&RecurringRevenueMonthly

&DI_&RecurringRevenueMonthlyWithTax

&DI_&RecurringRevenueQuarterly

&DI_&RecurringRevenueQuarterlyWithTax

&DI_&RecurringRevenueWeekly

&DI_&RecurringRevenueWeeklyWithTax

&DI_&RecurringRevenueWithTax

&DI_RecurringRevenueWithTax

&DI_&LineAttributeAltIsOverided

&DI_&LineAttributeExcluded

&DI_&LineAttributeGroupMember

&DI_&LineAttributeHidePrice

&DI_&LineAttributeHideQuantity

&DI_&LineAttributeIsRecurring

&DI_&LineAttributeOption

&DI_&LineAttributePrint

&DI_&LineAttributePrintPicture

&DI_&LineAttributeSelectedOption

&DI_&LineItemCount

&DI_&Picture

Macros NOT supported for Microsoft Word Templates

This list displays the macros that are not yet available for the Microsoft Word Templates.

Note:

Page numbers can be inserted into RTF attachments by inserting a page number on the document from within your RTF editor. If you're using Microsoft Word to edit your RTF documents, this is typically done by going to Insert -> Page Numbers.

Note:

Microsoft Word documents require the double less than (<<) and greater than ( >>) symbols prior to the macro and after the macro (e.g. <<&DH_SalesRepTitle>>) in order to be used in Microsoft Word templates.

Word merging also supports the DocumentItems CustomText01-CustomText14 Sections. This is similar to the ItemType Sections already supported in the Word Merging Feature. This enables you to separate out products using different classifications on your Microsoft Word based Quote or Proposal. For instance, if you use CustomText01 to hold the values of either Onsite or Remote assistance, you could have all Onsite assistance labor items on page 5 of a Word document by encasing it in "<<Begin.CustomText01.Onsite>>" and ending it with "<<End.CustomText01.Onsite>>". The Description field for each line could be printed in between these tags with "<<CustomText01.Onsite.&DI_Description>>". You could do the same for Remote by replacing Onsite in the macros.

QuoteValet Macros

Visit the QuoteValet Macros topic to see a list of all macros supported in QuoteValet.