Mail Merge - Group items by requestor name

[godlev]

I search many articles in Google and ExcelForum.com but I'm still not able to find solution for my case.

me and my friends we are making group orders from online shops and i want to automate the results from our orders.

In short words, i have an excel list with different amount of items that were purchased by different people

I want to create simple mail merge that will send all items purchased by requester X to his email and all items purchased by Y to her email.

hope that someone will help me find solution to this

I attached excel file example

[godlev]

Bump! - anyone got idea for this?

[godlev]

im still searching the net but cant seem to find solution
would appreciate if someone can help me...