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 Ian Courts, 89 Station Road, Balsall Common, Solihull, , CV7 7FN, 01 676 535490, 07836 733117, email@example.com
Councillor Karen Grinsell, C/o Solihull MBC, Council House, Manor Square, Solihull, B91 3QB, 07850 026366, , firstname.lastname@example.org
Councillor Ted Richards OBE, 102 Marlborough Road, Castle Bromwich, , , B36 0EL, 0121 747 6708, , email@example.com
Councillor Bob Sleigh OBE, 3 Holly Lane, Marston Green, Birmingham, , B37 7AP, , 07771 974402, firstname.lastname@example.org