mail merging filtered records..!

[via135]

hi all!

i am having sales data in A1:C100.
Col A has name of Location, Col B has name of Items & Col C has Quantity of Items Sold..!

A1:C1 is having header as LOCATION, ITEM & QUANTITY respectively..!!

What I want is to merge the data filtered on any one of the Col Headers
into a word document..!

For example
Col A ........... Col B..........Col C
Location .......Item...........Qty

BIG STREET ....PEN.............20
MARKET.........PENCIL.........30
BIG STREET.....PENCIL.........40
MARKET..........PEN............10

What I want is the filtered records on "Location", say ' Market'
ie) record no 2 & 4 into a Word Document through Mail Merging..!

any help please..?

thanks and regds..!

-via135