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 Nick Adams-King, The Little House, Stanbridge Earls, Awbridge, Romsey, SO51 0HE, , 07771 727402, firstname.lastname@example.org
Councillor David Drew, 1 Yew Tree Close, Goodworth Clatford, Andover, , SP11 7RR, 01264 357024, 07738 289902, CllrD.Drew@hants.gov.uk
Councillor Rob Mocatta, Old Down Farm, East Meon, GU32 1PL, , , , 01730 823908, , email@example.com
Councillor Sarah Pankhurst, c/o Members Secretariat, Hampshire County Council, Winchester, SO23 8UJ, , , , 07738 289844, firstname.lastname@example.org