MS Word Content Control

A content control is a document placeholder that automatically populates with data from your database. Insert these controls into your letterheads or envelope labels to dynamically update your information.

COMMON CONTROLS

CONTROL	DESCRIPTION
ALIASNAME	Contact preferred name
CLIENTID	Contact unique identification number
GENDER	Contact gender (M/F)
SALUTATION	Contact title eg Mr, Mrs
FIRSTNAME	Contact first name
LASTNAME	Contact lastname name
FULLNAME	Contact full name like Citizen, John
JOBTITLE	Contact job title
COMPANY	Contact employer
BUSINESSSTREET	Contact employer street address
BUSINESSCITY	Contact employer suburb
BUSINESSPOSTCODE	Contact employer postal code
BUSINESSSTATE	Contact employer state
BUSINESSCOUNTRY	Contact employer country
STREET	Contact street address
CITY	Contact suburb
STATE	Contact state
POSTCODE	Contact postal/zip
COUNTRY	Contact country
DATE	Date format 1/01/1970
DATE-LONG	Date format Sunday, 1 January 1970
TIME	Time format 09:00 AM
TIME-LONG	Time format 9:00:00 AM
HOST-SCHEME	Host scheme eg as https
HOST-NAME	Host name eg ds08-training.azurewebsites.net
HOST-PORT	Host port eg 443
MODIFYDATE	Record last update

CLIENT RECORDS (inherits COMMON)

CONTROL	DESCRIPTION
LASTCONTACTDATE	Client last contact eg 1/01/1970
INITIALCONTACTDATE	Client first contact eg 1/01/1970
EMAIL	Client email
MOBILENUMBER	Client mobile phone
HOMENUMNBER	Client home phone
PRIORITY	Client priority eg. High, DNC
METHOD	Client inquiry eg. walk-in
REFERRAL	Client referral eg. TV ads, Open day
PROXY	Client inquiry on behalf, eg. for Parents
VILLAGE	Village name
LATITUDE	Village GPS latitude position
LONGITUDE	Village GPS longitude position

RESIDENT RECORDS (inherits CLIENT)

CONTROL	DESCRIPTION
BIRTHDATE	Resident date of birth eg 1/01/1970
ARRIVALDATE	Resident entering village date
DEPARTUREDATE	Resident leaving village date
PROXNUMBER	Resident prox key number
KEYTAG	Resident key tag number
CARREGO	Resident car registration number
RELIGION	Resident religious belief
MEDICARENUMBER	Resident medicare number
AMBULANCENUMBER	Resident ambulance number
MARITALSTATUS	Resident marital status
PENSIONNUMBER	Resident pension number
HEALTHFUND	Resident health fund
HEALTHFUNDNUMBER	Resident health fund number
CAVEATNUMBER	Resident caveatnumber
WILLLOCATION	Resident will location
NOTES	Resident notes
UNIT	Resident ILU or unit
VETERANAFFAIRS	Resident veteran affairs number
EVACUATIONLOCATION	Resident evac location during emergency
DEATHDATE	Resident date of death
STREET	Resident ILU street address
CITY	Resident ILU suburb
POSTCODE	Resident ILU postal code
STATE	Resident ILU state
COUNTRY	Resident ILU country
ADDRESSCODE	Resident ILU address code
LOTNUMBER	Resident ILU lot number
ELECTRICITY	Resident electricity account
WATER	Resident water account
GAS	Resident gas account
SETTLEMENTDATE	Resident settlement date
SETTLEMENTVALUE	Resident settlement price
MARKETVALUE	Resident ILU market value
VALUATIONDATE	Resident ILU market valuation date
AGENEXTBIRTHDAY	Resident age next birthday

JOINT RESIDENTS RECORDS (inherits RESIDENT)

CONTROL	DESCRIPTION
PLACELABEL	ILU number
SALUTATIONS	Combine salutations eg Mr & Mrs
FIRSTNAMES	Combine first names eg John & Mary
LASTNAMES	Combine last names eg Smith, Smith & Rogers
ALIASNAMES	Combine prefer names eg Jo & Mick
FULLNAMES	Combine fullnames eg Smith, John & Mary