Mail merge by list

[csk003]

I am trying to mail merge the following in MS Word 2003.
My database looks like below:

City Address Store Count
City1 Address1 Store1 4
City1 Address1 Store2 50
City2 Address2a Store1 80
City2 Address2a Store2 56
City2 Address2a Store3 7
City3 Address3b Store1 80

I want to have a mail merge documents as follows.
I need to group them by city and send mail to all stores within the city to the same address(which is main address)
Can this be possible?
----------------------------------------------------
To

City1
Address1

List of stores and count
Store1 4
Store2 50

-----------------------------------------------------

----------------------------------------------------
To

City2
Address2a

List of stores and count
Store1 80
Store2 56
Store3 7

-----------------------------------------------------
----------------------------------------------------
To

City3
Address3b

List of stores and count
Store1 80
-----------------------------------------------------

 

[SkipVought]

Hi,

Check out Mail Merge in Excel faq68-4223

Skip,

_{[red]Be advised:[/red]
Alcohol and Calculus do not mix!
If you drink, don't derive!}

 

[csk003]

The problem is I am not able to do mail merge if I need to access data from different rows in excel(i.e grouping by Column). I am not sure how I can program the list /grouping by category.