[Roxy]

How do I set up a mail merge template using an excel file as the database but
keep formating of the width of a field so a label uses set number of
characters despite the length of a specific field within excel file?

[macropod[_2_]]

Hi Roxy,

You can't. If the data need to be truncated, you have to do that at the data source.

Alternatively, if you put the mergefields into table cells of the required fixed width, that will limit the amount of text that will
be displayed. Do note, however, that this only works as a character limiter if you're using a fixed-width font (eg Courier). If you
use a proportional-width font, the number of characters that will fit varies according to the individual character widths. In both
cases, you'll need to be careful with the cell widths, as you're liable to end up with parts of characters printing at the end of
the cell - you're unlikely to be able to prevent this with a proportional-width font.

--
Cheers
macropod
[MVP - Microsoft Word]


"Roxy" wrote in message ...
How do I set up a mail merge template using an excel file as the database but
keep formating of the width of a field so a label uses set number of
characters despite the length of a specific field within excel file?