When choosing label size and shape, keep in mind the number of lines which will be displayed. Select the type of printer and labels you wish to use. The label options dialog box is now displayed. Now open Microsoft Word, click the 'Mailings' tab, then 'Start Mail Merge' and 'Labels.' Once you have specified a location and name, hit 'Save' and close Excel. At this point, you can choose where to save the file and assign a different name if you wish. In Excel, click the Office Button (in the top left corner) and choose 'Save As' and 'Excel Workbook.' A dialog box will open. Once the file has been saved to your computer, open it using Excel. In the screen below, for example, the file is saved to the user's computer desktop. Select 'Submit' and then 'Save' to save the file to the desired location on your own computer or network drive. The filename may be changed to whatever you wish, but be sure to preserve the. However, KCR only supports label printing using Microsoft® Excel and Microsoft® Word.Ĭhoose the 'Save' button and a dialog box will appear with the default filename 'Labels.csv' and 'comma separated' as the specified file format. Note: Once labels have been generated by and saved to a user's computer, the file may be manipulated and printed using any type of spreadsheet and/or word processing software. The labels will then be displayed, as seen in the example below: From the Reports submenu, create the desired label type (Follow-up, Patient, etc.).

Mail merge labels from excel