866,272 Users Worldwide | Login

Template fields

Supported fields for E-mail, Excel, and PowerPoint exporting

When creating an e-mail, excel or powerpoint template, LiveProject supports almost every column used in Microsoft Project.

Field Naming

Fields are entered between <> characters, and consists of a Type and a Name. For example <R:Resource Name>.

The Types are:

  • R for Resource fields, for example <R:Email Address>
  • T for Task fields, for example <T:Task Name>
  • P for Project fields, for example <P:Manager>

The Names match the column names from Microsoft Project (See list below).


When creating a e-mail, excel or powerpoint template, you can create what we call a LiveProject Group. These groups are indicated with the <LPGROUP> start tag, and </LPGROUP> end tag.

When for instance an e-mail is generated, groups are repeated for each task, thus making it possible to create lists of tasks.

Fields that are not inside a group will contain ALL the values for that field. In the example below, note that <R:Resource Name> is used outside the LPGROUP, and thus contains all the resource names for the selected tasks.

Here is the template for the Short Tasklist:

Dear <R:Resource Name>.

Please review your tasks on project "<P:Title>" listed below.

<LPGROUP>Task:<T:Unique ID> : Responsible: <T:Resource Names>
We are running late, this needs your attention asap!

Regards, <P:Manager>

This code will generate a mail like this, given 3 tasks are selected:

Dear Deborah Finurli;Anna Langly;Bert Finklestein;George Swift.

Please review your tasks on project "Zanzibar" listed below.

Task:83 : Responsible: Deborah Finurli, Anna Langly
Task:84 : Responsible: Deborah Finurli, Bert Finklestein
Task:85 : Responsible: George Swift, Anna Langly

We are running late, this needs your attention asap!

Regards, Jari Niskala

Note: For MS Project custom fields, use the original field name. If for instance you rename "Text1" to "Machinery", you still need to use <T:Text1> in the template.

Resource Fields

<R:% Work Complete>
<R:Accrue At>
<R:Actual Cost>
<R:Actual Overtime Cost>
<R:Actual Overtime Work>
<R:Actual Work>
<R:Available From>
<R:Available To>
<R:Base Calendar>
<R:Baseline Cost>
<R:Baseline Work>
<R:Cost Per Use>
<R:Cost Variance>
<R:Email Address>
<R:Hyperlink Address>
<R:Hyperlink Href>
<R:Hyperlink SubAddress>
<R:Material Label>
<R:Max Units>
<R:Overtime Cost>
<R:Overtime Rate>
<R:Overtime Work>
<R:Peak Units>
<R:Regular Work>
<R:Remaining Cost>
<R:Remaining Overtime Cost>
<R:Remaining Work>
<R:Resource Name>
<R:Standard Rate>
<R:Unique ID>
<R:Windows User Account>
<R:Work Variance>

Task Fields

<T:% Complete>
<T:% Work Complete>
<T:Actual Cost>
<T:Actual Duration>
<T:Actual Finish>
<T:Actual Overtime Cost>
<T:Actual Start>
<T:Actual Work>
<T:Baseline Cost>
<T:Baseline Duration>
<T:Baseline Finish>
<T:Baseline Start>
<T:Baseline Work>
<T:Constraint Date>
<T:Constraint Type>
<T:Cost Variance>
<T:Duration Variance>
<T:Early Finish>
<T:Early Start>
<T:Effort Driven>
<T:Finish Slack>
<T:Finish Variance>
<T:Fixed Cost Accrual>
<T:Fixed Cost>
<T:Free Slack>
<T:Hide Bar>
<T:Hyperlink Address>
<T:Hyperlink Href>
<T:Hyperlink SubAddress>
<T:Ignore Resource Calendar>
<T:Late Finish>
<T:Late Start>
<T:Level Assignments>
<T:Leveling Can Split>
<T:Leveling Delay>
<T:Outline Level>
<T:Outline Number>
<T:Overtime Cost>
<T:Preleveled Finish>
<T:Preleveled Start>
<T:Regular Work>
<T:Remaining Cost>
<T:Remaining Duration>
<T:Remaining Overtime Cost>
<T:Remaining Work>
<T:Resource Names>
<T:Start Slack>
<T:Start Variance>
<T:Subproject File>
<T:Task Calendar>
<T:Task Name>
<T:Total Slack>
<T:Unique ID>
<T:Work Variance>

Project Fields

<P:% Complete>
<P:Actual Duration>
<P:Current Date>
<P:Days Per Month>
<P:Finish Date>
<P:Minutes Per Day>
<P:Minutes Per Week>
<P:Start Date>

See also:

You are viewing the online version of the LiveProject help files. Click here for KaDonk's main pages.