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
Andy Street, c/o West Midlands Combined Authority, 16 Summer Lane, Birmingham, , B19 3SD, , , email@example.com
Councillor Mike Bird, Hawks Ridge, 54 Charlemont Road, Walsall, , WS5 3NQ, 01922 653238, , firstname.lastname@example.org
Councillor Ian Brookfield, c/o Civic Centre, St Peter's Square, Wolverhampton, , WV1 1SH, 01902 550352, , email@example.com
Councillor Kerrie Carmichael, 6 Goths Close, Rowley Regis, West Midlands, , B65 9RQ, 0121 569 3112, , firstname.lastname@example.org
Councillor Ian Courts, C/o Council House, Manor Square, Solihull, , B91 3QS, , 07836 733117, email@example.com
Councillor George Duggins, c/o Coventry City Council, Council House, Earl Street, Coventry, CV1 5RR, (024) 7683 1003, , firstname.lastname@example.org
Councillor Patrick Harley, 12 Hazel Road, Kingswinford, , , DY6 8EZ, , , email@example.com
Councillor Ian Ward, c/o Birmingham City Council, Council House, Victoria Square, Birmingham, B1 1BB, (0121) 303 4155, , firstname.lastname@example.org