I am using MS Word and Excel to create badges (labels).

I would like to include every line even if the field in a line is empty.
i.e.

FirstName LastName
Title


Company

When I merge the data, records without a title end up appearing like this:
FirstName LastName
Company

I want it to appear like this:
FirstName LastName

Company

If you add the Mail Merge Helper button to Word's QAT, you can do the merge setup as per normal but, instead of clicking on Finish & Merge, click on the Mail Merge Helper button and choose:
Merge>When merging records:Print blank lines when data fields are empty>Merge.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]