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 Ben Aveyard, 239 Wortley Road, Rotherham, , , S61 1LJ, 01709 807951, 07748911662, firstname.lastname@example.org
Councillor Victoria Cusworth, c/o Rotherham Town Hall, Moorgate Street, Rotherham, South Yorkshire, S60 2TH, 07824895314, , email@example.com
Councillor David Roche, 8 Moorland Court, West Melton, Rotherham, , S63 6DD, , 07792 421800, firstname.lastname@example.org