Step 3: Type or paste in your customer or lead list directly into Excel.
Step 4: Save your mailing list.
Step 5: Open a MS Word document.
Step 6:Go to the Mailings Menu > Start Mail Merge >Step by Step Mail Merge Wizard.
How do I create a Mailings tab in Excel?
Right-click on the Quick Access Toolbar and choose Customize the Ribbon. In the ensuing dialog, in the right-hand panel, click the Mailings box to check it. Click to add any other missing tabs.
Related Question how to make mailing labels from excel 2010
How do I merge labels from Excel to Word 2010?
Excel File as the Recipient List.
Structure of the Recipient List.
Number and date formatting may not appear in the merged document.
Confirm File Format Conversion on Open.
Warning When Opening a Word Mail Merge Main Document.
Display Mail Merge Wizard Task Pane.
Choose Labels for the Document.
Select the Label Size.
What format does excel need to be in for mail merge?
An essential step in a Word mail merge process is setting up and preparing a data source. You can use an existing Excel data source or build a new one by importing a tab-delimited (. txt) or comma-separated value (. csv) file.
How do I create a mail merge document?
Click the Mailings tab.
Click the Start Mail Merge button.
Select Step-by-Step Mail Merge Wizard. The Mail Merge pane appears on the right, ready to walk you through the mail merge.