Hi Rachel?/Simon?,

I'm not sure I should help someone who classifies Coorong Shiraz as a Rose ...

Your Excel workbook really isn't laid out in a format that is conducive to a mailmerge based on glass, half bottle and bottle groupings, as appears to be your aim.

With the current layout, having different groupings according to whether a wine is sold by the glass, half bottle or bottle, would require a filter based on the corresponding column. The Directory/Catalogue merge could then take care of arranging the records by wine type. Essentially, this means you'd need to do three separate merges to generate a full wine list.

To be able to do this all as a single mailmerge would require a separate line for each of the sale types for a given wine. Thus, you'd have two lines for the Billecart Salmon Brut - one for the bottle price and one for the glass price.

Conversely, if all you wanted to do is to classify the wines by type and have three separate columns for the glass, half bottle and bottle prices for each type, that could readily be done with your existing workbook, simply by using the 'Type' column for the key.

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