[AccessD] Mailing Labels

Given the following data
 
1234,Name,Address
1234,Name,Address
1234,Name,Address
1234,Name,Address
2345, Name Address
2345,Name Address
 
I need to get one mailing label produced 
 
1234, Name1, Name2,Name3,Name4
Address
 
2345,Name1,Name2
Address
 
Etc
 
So I can have multiple people at the same address. I need the name line to include all the names but only produce 1 label per address.
 
Martin
 
 
Martin WP Reid
Training and Assessment Unit
Riddle Hall
Belfast
 
tel: 02890 974477