Mail merging always seems to cause a complete blank look in our office – but it really is easy with Word and Excel. This video is quite long but it tells you everything you need to know and shows it to you in a way that will enable you fully understand how to prepare your spreadsheet data and your letter or email for mail merging.
Some users may comment that this is not hardcore Excel – I agree – but I use Excel to do exactly this at least once a month and I know people who have all the data in Excel but then cut and paste it to Word for each letter !!!!
Enjoy and I hope this helps you expand you use of Excel.