castm.blogg.se

How to do a mail merge from excel for labels
How to do a mail merge from excel for labels




Note: You can click Details for more specific information about the label chosen or click New Label to describe a custom label. In the Label information section, select the brand of your label from the Label products drop down list, and the specific label item number from the Product number scrolling list.In the Printer information section, select the type of printer you will use and the tray in which the label sheets can be found.In this dialog box, you can do the following: Under the Change document layout heading, click Label Options. On the task pane, under the heading Step 1 of 6, click Next: Starting document.Ħ. Click to bullet the Labels radio button.ĥ. From the Tools menu, point to Letters and Mailings, and then select Mail Merge from the submenu. The Mail Merge toolbar is added above the open document.ģ. On the View menu, point to Taskbars, and then select Mail Merge. Start MS Word and leave the new blank document on your screen.Ģ. Note: There must be a heading for each column this gives the column a name used during insertion into the main document.ġ.

how to do a mail merge from excel for labels

Save your document! To populate the fields in a mailing label, a spreadsheet or table similar to the one below is required:

how to do a mail merge from excel for labels

You can use either a MS Excel spreadsheet or a MS Word table to create the data source containing the personal information which will vary on each mailing label. Note: Using these steps the main document and data source can be created and modified in more than one editing session. Use the Mail Merge Helper to open, modify and merge the main document and data source. Create the data source (using a MS Word table or a MS Excel spreadsheet).Ģ. The most efficient way of performing a mail merge is:ġ. You can collect the merged information into a new document to be reviewed and printed later, or you can send the documents directly to a printer. Each record (or row) of the data source produces an individual mailing label with the personalized information of the recipient.

how to do a mail merge from excel for labels

The Mail Merge process reads data from one record (or row) of the data source and inserts values from it into the appropriate merge fields in the main document. The main document contains merge fields, which are place holders that tell Microsoft Word where to insert data from the data source.

how to do a mail merge from excel for labels

The data source contains text specifying names and addresses to be used on the mailing labels. The main document contains text arranged into standard mailing label formats.Ģ. The Mail Merge Helper assists you in the creation of labels using two data files:ġ.






How to do a mail merge from excel for labels