how to print address labels with MS word based on datas merged from access or excel?
On each page, there will be few rows of labels, and all of them should not be identical.
It should be one after the other following the list.
- williamh772Lv 51 decade agoFavorite Answer
Click Tools, Letters and Mailings, Mail Merge Wizard... The task pane will open on the RHS of your screen. This is the first of 6 steps/panes.
Click the radio button for Labels. At the bottom of the pane click Next: Starting document.
In the next pane, click 'Label options...' and choose the exact one. Click Next: Select recipients.
Now, do you have an existing list, or an Access database with the data (that you can browse to), an Outlook Contact list, or do you want to type in the list now (here you must click the Create button and enter each one [recipient])?
When the Mail Merge Recipients dialogue box opens, make sure that all of the names that you want to appear on the labels are checked along the LHS of this list.
Click Next: Arrange your labels
Is there an address block or are you entering each item (merge field)? If so, click More items.. and (in the Insert Merge Field dialogue box) select the first item, click the Insert button (at the bottom of the dialogue box) and the Cancel button to the right of this will change and say Close--click this Close button. Be sure to hit the space bar one time before entering the next merge field (or the text on your labels will run together). Repeat this process for the next merge field, and so on.
Now click the 'Upgade all labels' button.
Click Next: Preview your labels
Here you can click the forward and back symbols to the right and left of Recipients to see each name.
Click Next: Complete the merge
Click Print... and the Merge to Printer dialogue box opens. Click the All button and click OK. The Print dialogue box will open. Click OK.
That should do it!
- pratchmgLv 41 decade ago
Excel is the easiest to use for Mail Merge. Go into excel and type the name/label on the first line row of data. Highlight the row and make it bold so that it can be recognised as being a header. you can then put all the information for example, names, addresses and telephone numbers for as many people as is required for the mail merge.
Next go into Word and Tools, Leeters and Mailings and select Mail Merge - in stept 2 select "Select the recipients" and use from an existing list.
This will bring up a box to slect from data sources - use the drop down menu to select Excel or .xls file. You can then look in the area where you have saved your Excel spreadsheet.