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 G. N. Denaro, 32 Beaudesert Road, Hollywood, Birmingham, , B47 5DP, , 07828 335507, firstname.lastname@example.org
Councillor S. R. Colella, 24 Lodge Crescent, Hagley, Stourbridge, West Midlands, DY9 0NB, 01562 882996, , email@example.com
Councillor S. A. Robinson, c/o Bromsgrove District Council, Parkside, Market Street, Bromsgrove, B61 8DA, , 07827515166, firstname.lastname@example.org
Councillor Harrison Rone-Clarke, 7 Harbours Close, , Bromsgrove, , B61 7HL, , 07548 353125, email@example.com
Councillor S. A. Webb, c/o Bromsgrove District Council, Parkside, Market Street, Bromsgrove, B61 8DA, 01527 882392, 07818516682, firstname.lastname@example.org