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 Joan Dixon, Derbyshire County Council, County Hall, Matlock, Derbyshire, DE4 3AG, , 07748 920070, firstname.lastname@example.org
Councillor Barry Lewis, 2 King George Street, Wessington, Alfreton, Derbyshire, DE55 6DZ, 01629 536003, 07920 484207, Barry.Lewis@derbyshire.gov.uk
Councillor Simon Spencer, Derbyshire County Council, County Hall, Matlock, Derbyshire, DE4 3AG, 01629 536001, 07780 222564, Simon.Spencer@derbyshire.gov.uk