Mail merge unique records only...

[cliffhanger9]

Hi all

I am doing a mail merge and have a tab delimited text file with 10 fields as the data source. I only need the data from two of them - the product number and price.

There are a lot of duplicate records that I would like to not merge into the mail merge template. I cannot alter the data source so this will have to be done with Word field codes.

I have potential solution to this using some combination of fields in word but am unable to get it to work.


here is the link i found

http://support.microsoft.com/?kbid=302665

here is what i have written - doesnt work

{IF {MERGESEQ} = "1" "{MERGEFIELD itemnum}
{MERGEFIELD itemprice}" ""}{SET itemnum1 "{MERGEFIELD itemnum}"} {IF {itemnum2}<>{itemnum1} "" ""}{SET itemnum2 "{MERGEFIELD itemnum}"}

thanks in advance