All articles with 'mail merge' Tag

Use mail merge to create custom letters, invoices, labels and more

Published on Aug 17, 2015 in Excel Howtos
Use mail merge to create custom letters, invoices, labels and more

The idea of mail merge is simple & powerful. Imagine you handle¬†recruitment at a large company. You just hired 300 analysts for the big data division. The next job – generate employment offer letters for each of them. Of course, you don’t want to type these letters one at a time. You have the details of all the 300 offers (name, email, address, offer code, role, benefit package details and date of joining etc.) in a spreadsheet. You also have a¬†template of the offer letter.

Enter mail merge. This powerful feature of MS Word combines (Excel) data with Word document contents to generate all the 300 letters in just few minutes.

Continue »