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
Charlotte Atkins, South View, Park Road, Leek, , ST13 8JU, 01538 371188, , firstname.lastname@example.org
Jonathan Price, 4 Clement Close, Stafford, , , ST16 3NS, , 07792 024858, email@example.com
Paul Snape, 47 Southgate End, Cannock, Staffordshire, , WS11 1PS, , 07528 958238, firstname.lastname@example.org
Mark Sutton, Cabinet Office, Wedgwood Building, Tipping Street, Stafford, ST16 2DH, , , email@example.com
Mike Worthington, (Address not supplied) , , 07507 066911, firstname.lastname@example.org