How to do a Mail Merge and print labels from Excel 2007:
- Open Word
- Go to Mailings tab
- Click on Start Mail Merge icon and select Step by Step Mail Merge Wizard
- Panel opens on right hand side of Word window
- Select Document type, in this case Labels
- Click Next
- Step 2 of 6, click on Label Options to select type and size of label. This is organised by manufacturer and then their product type. This ensures the address details are printed in the right place and in the right size. Then click Next: Select Recipients.
- Step 3 of 6, Ensure "Use and existing list" is ticked and then click on Browse to find your saved Excel address list.
- A new window will open called "Select Table", and make sure that the bottom left hand corner tick sbox is ticked. This will ensure that Word picks up the correct fields from Excel and recognises what they are.
- A new window will then appear showing the details from the address list, called "Mail Merge Recipients". You can tweak the list by using the clickable options below the address list.
- Step 4 of 6, Arrange your labels as you would like by clicking on More Items to bring up a ne window called "Insert Merge Field". Insert each field and choose the layout you would like.
- Step 5 of 6, Click Complete the Merge, and then Click Print on Step 6.
