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
Ryan Brent, (Address not supplied)
Councillor Suzy Horton, C/o Members' Services, Floor 3 Civic Offices, Guildhall Square, Portsmouth, PO1 2AL, , 07973 - 269105, firstname.lastname@example.org
Councillor Judith Smyth, C/o Members' Services, Floor 3 Civic Offices, Guildhall Square, Portsmouth, PO1 2AL, , 07974 - 820226, Cllr.Judith.Smyth@portsmouthcc.gov.uk
Councillor Rob Wood, Flat B Aquitane House, 2 Grand Parade, Portsmouth, , PO1 2NF, , 07980 - 681053, email@example.com