I've another problem that may have no solution but hopefully someone will have some ideas...
I need to mail merge some data from an excel list into a standard letter in Word. The data has 3 columns: Dealer, REG and MODEL.
For each Dealer there may be from 1 to 50 vehicles and there are several hundred Dealers. The problem is that i need one letter for each Dealer and a list of the related vehicles on the letter.
I need to know how i can group the data so that the merge takes the, say, '7' vehicles in the '7' rows that Dealer 'x' has and not produce 7 letters one for each vehicle.
Is this clear? Hope so...
Thanks alot
I need to mail merge some data from an excel list into a standard letter in Word. The data has 3 columns: Dealer, REG and MODEL.
For each Dealer there may be from 1 to 50 vehicles and there are several hundred Dealers. The problem is that i need one letter for each Dealer and a list of the related vehicles on the letter.
I need to know how i can group the data so that the merge takes the, say, '7' vehicles in the '7' rows that Dealer 'x' has and not produce 7 letters one for each vehicle.
Is this clear? Hope so...
Thanks alot