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 Jeremy Oates, (Address not supplied)
Councillor Daniel Cook, (Address not supplied)
Councillor Doug Pullen, C/O Democratic Services, Lichfield District Council, Frog Lane, Lichfield, WS13 6YU, , , email@example.com
Councillor Ashley Yeates, C/O Democratic Services, Lichfield District Council, Frog Lane, Lichfield, WS13 6YU, 0121 323 2200, , firstname.lastname@example.org