You must send the same letter to several different recipients? No need to type each letter, so that only a few different details. Indeed, by performing a mail merge, you can automatically create a series of letters and envelopes in which only the coordinates and the recipient information is changed. In short, it is a huge time saver.
- To perform a mail merge, you will need to initially establish a database of the recipient list and related information and reference you need for your mail (name, address, gender, ...). This database can be performed in an Excel spreadsheet.
- The second step is to create the template letter and envelope that you want to use.
- Finally, it will do so only to mix it all to automatically create and print letters and envelopes.
Create a database with Excel
The picture you are going to do in Excel will be your complete source for all your letters and envelopes. It should contain a list of persons to whom you send your letters and contact information. To do so :
- Launch Excel.
- Create a table with columns for the following information: Title, Name, Name, Address, Postal Code, City. If you want to include other personal information in your personalized letters, you can of course add as many columns you want.
- Then fill the array with the list of persons to whom you send your letters.
- Save your Excel file in the file ListePublipostage.xls example.
Bookmarks