Each address below is displayed as a comma separated value (CSV) list. You can copy and paste this information into a text file. Open the file in your word processor or spreadsheet for use in mail merges.
To use this information as a mail merge in a Microsoft Word document, copy and paste all the names and addresses including the headings 'Name, Address1 etc' into a Word document. To put it into table format: Highlight all the text, go to Table/Convert text to table/Make sure 'separate text at commas' is chosen then OK.
Name, Address1, Address2, Address3, Address4, Postcode, Phone, Mobile, Email
Councillor S. R. Colella, 24 Lodge Crescent, Hagley, Stourbridge, West Midlands, DY9 0NB, 01562 882996, , firstname.lastname@example.org
Councillor R. J. Deeming, 502 Groveley Lane, Cofton Hackett, Rednal, Birmingham, B45 8UB, 0121 4453114, , email@example.com
Councillor M. Glass, c/o Bromsgrove District Council, Parkside, Market Street, Bromsgrove, B61 8DA, , 07791 187901, firstname.lastname@example.org
Councillor S. G. Hession, c/o Bromsgrove District Council, Parkside, Market Street, Bromsgrove, B61 8DA, , 07973821556, email@example.com
Councillor R. J. Hunter, c/o Parkside, Market Street , Bromsgrove, Worcestershire, B61 8DA, 01527 578337, , firstname.lastname@example.org
Councillor M. Middleton, c/o Bromsgrove District Council, Parkside Market Street, Bromsgrove, Worcestershire, B61 8DA, , 07877760175, email@example.com
Councillor Harrison Rone-Clarke, 7 Harbours Close, , Bromsgrove, , B61 7HL, , 07548 353125, firstname.lastname@example.org