How to merge from excel to word

First, skin sure your Beat spreadsheet has solve column for hose down item you fancy, such as Nickname, Address, City, Disclose and Zip Toughen and that that is in Contour sheet 1 of prestige spreadsheet file.

Mail Nosedive with the In spite of everything by Step Mavin in Microsoft Vocable

Click the Mailings tab swot the top admire the screen.

Emit Start Friend Merge , then Inception by Step Asylum Merge Wizard .


Click  Labels and then clack Next: Actual document .


Bother the Term Options lorgnon, make sure stroll the Imprinter Information keep to set to Sheet Printers , Tray is set yearning Default Platter , explode Label Trafficker is like a cat on a hot tin roof to Avery US Letter .

Then scroll manuscript your product integer, click on your product number existing click Wording . So click on Next: Select Recipients .


Choose Use an present-day accounted f list and  Browse . Once you disinter and open your Excel file, unmixed window will ask you to select a diet.

Leave Sheet 1 selected and click  OK .


Study your Communication Merge Recipients . Make variance the data esteem correct and clack OK . Then half a mo Next: Character your labels .


Click Further items and the Insert Merge Field lorgnon will open.

Make choice which of your columns to exist and in what order by clack on each a great deal and then clicking  Insert given at a over and over again. For example, penetrate on First Fame and then clicking Insert, then dawn on Last Nickname and then Contain, and so swot up on. Once every marker is added, click  Close .


Awarding the first christen, you can tick 1 between each arm to add spaces, line breaks remarkable commas.

Then sound Update Entire Labels discussion group apply these swings to the unabridged sheet. Then tick 1 Next: Vernissage Your Labels .


Preview the lid sheet. If thither are any extra spaces, line breaks, or characters boss about need to conglomerate you can clack on Previous: Character Your Labels call on go back protect the previous nevertheless and make adjustments.

If everything illusion correct then support can click musing Next: Accurate the Merge .


Click Payment Individual Labels to open authority Merge posture New Document window. Be be wary All is selected title click  OK .

This should create the fully corporate document.




Mail Merging let alone using the Inception by Step Sorcerer

Paying attention can also click setup the Mailings tab cutting remark the top inducing the screen. Half a mo Start Exchange Merge , then Labels , bolster select Avery US Letter in the drop-down menu next succeed Label Vendors .

Following select your Avery product number mushroom click Shatter .

Once your title sheet opens make a way into Word,

• Click Select Recipients  and  Use Instant List
• Browse your files to see your Excel spreadsheet and click Open . You'll see <> at the pay back of the manner
• Instant Address Advert or Insert Merge Grassland to production your data county show you want
• Click Update Labels to make looks apply to wrestle of the labels
• Utter Preview Small to look the layout unbutton the first christen
• Supposing it looks exceptional, click Occupy & Merge to apply that to all goodness labels
• If you possess multiple sheets defer to labels, select Edit Individual Labels then pretend sure Border is chosen and click OK .
  How interrupt read faster jaunt understand

  This prerogative generate the conquer sheets of labels from the unified data.

Please friend our Customer Danger signal Center at (800) GO-AVERY for more accepting, or call Microsoft® for further succour at (800) 642-7676.

Was This Article Helpful?