Open a brand new excel spreadsheet and copy / paste in your list of names and addresses into the first sheet. The following Excel formulas will get you from this list to an Excel spreadsheet you can mail merge from with Word. Name 2, address 1, town, county, postcode, country If this happens, it makes it a little tricky to perform a standard mail merge with Microsoft Word (note it is possible to set rules for this, but the following is probably going to be easier!). Or you’ll have the whole lot with commas. If you have a list, or spreadsheet, of addresses, often you’ll have the name in one column, and the address in the other, with each line separated by commas.

MailMerges can save an awful lot of time when it comes to writing down and printing addresses, but there is often an issue in the way addresses were collected that make the way we have them written down quite tricky to work with. Step Five – Save Your Excel Workbook & Complete Your Mail Merge.

Step Four – Import The Content Using Formulas.Step Three – Put Headers into Sheet Two.Step One – Start a New Excel Spreadsheet.

Copy paste list into excel