Hi - I have a spreadsheet that contains following fields:

Customer Name, Address etc.
Product Name
Product Price/Total

I need to set up my mail merge so it brings in the Customer record for each letter BUT ALSO brings in ONLY the Product items where a currency value is present in the Price field.

I have found a solution to bringing excel currency format across to word merge field so thats ok.

BASICALLY - I want it to merge a list of PRODUCT ITEMs from the Product Mail Merge Field IF there is a value in the adjacent Price Merge Field (from the spreadsheet.) and leave out any blank Price fields.

I cant figure out how to set up either the s/sheet or the mail merge fields in word.



I hope that is a clear explanation - but I don't think it can be too hard to do.

Any help appreciated.