Set up mail merge in Excel and Word

摘要

If you want to post letters to members, you could spend ages addressing each letter and label or envelope by hand, but that would be a huge waste of time. The process of mail merging does all the hard work for you, creating a batch of letters personalised for each member, letting you choose who to include each time. The first thing you need is a data source containing the details of everyone the mailing will be posted to. We'll use Excel for this, though you can perform a mail merge in both LibreOffice and Google Drive (using Sheets). Open a spreadsheet, and in a header row at the top add columns for Last Name, First Name, Address, Town/City, County, Postcode, Phone Number, and Email Address.