Create Title

Location on ribbon: Tab DVD Addin → Group File and Print → Menu Merge Menu

Command ID: btnCreateTitle

What it does

Wraps each header cell of a table in square brackets [...] so it becomes a mail-merge field. This is the preparation step for the Merge to Word command: DVDAddin matches placeholders in the Word template by the literal string [Column name].

Site engineers use it when a single Excel table has to produce a stack of documents — inspection request forms, concrete sampling records, work assignment slips — one document per data row.

How to use

1. Open the sheet holding the data table with a proper header row (one name per column).
2. Go to tab DVD Addin → group File and Print → Merge Menu → Create Title.
3. Excel's range picker appears, titled DVD Addin — Create title row, prompting you to select the title row to wrap with [...].
4. Drag-select the header row (for example A3:H3) and click OK. Cancel exits without changing anything.
5. The add-in rewrites every cell on the first row of the picked range as [old value] and reports "Created N title fields."
6. Use the prepared table as the data source for Merge to Word.

Example

A table tracking inspection request forms:

Before	After
Form No.	[Form No.]
Work package	[Work package]
Activity inspected	[Activity inspected]
Inspection date	[Inspection date]
Location	[Location]

In the Word template for the inspection record you then type the exact strings [Form No.], [Inspection date] and so on where the values belong; Merge to Word substitutes them row by row.

Notes

• Only the first row of the selected range is processed — one cell per column. Selecting the whole table leaves the data rows untouched.
• Running the command twice on the same header row nests the brackets into [[Column name]]; check before clicking again.
• An empty header cell becomes [], so fill in every column name first.
• The command overwrites cell values, so it cannot be undone with Ctrl+Z. Keep a copy of the workbook for important tables.
• A header cell containing a formula is replaced by the plain text [result] — the formula itself is lost.

Related

• Merge to Word — the next step; it consumes the [...] fields you just created.
• Email Template — template documents that use the same field mechanism.
• Send Email — bulk sending driven by a table with normalised headers.