How Do You Create A New Mail Merge Data Source?
The mail merge feature is widely used in productivity software like Microsoft Word and Microsoft Excel. It allows users to easily create large numbers of similarly-formatted documents using one template and a consistently structured data source. Items commonly created with a mail merge include personalized letters, envelopes and mailing labels. Because it sorts data into clear columns and row and allows for quick additions and deletions, developing a spreadsheet is the most intuitive way to create a new source for mail merge data. Create a new spreadsheet file. Microsoft Excel is the most widely used spreadsheet software, but alternatives like the free OpenOffice Calc program work just as well. After opening your spreadsheet program, click “File” in the menu and select “New” to create a blank workbook. Add column labels. The first row in your spreadsheet must be a label for the column’s rows (e.g. Name, Address). Each name must be unique and no column label should be left blank. Add ma
