Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-16-2021, 09:17 PM
Jay Chang Jay Chang is offline Creating labels with an Excel Doc Containing Sku # and Sku Description Windows 10 Creating labels with an Excel Doc Containing Sku # and Sku Description Office 2019
Novice
Creating labels with an Excel Doc Containing Sku # and Sku Description
 
Join Date: Feb 2021
Posts: 2
Jay Chang is on a distinguished road
Default Creating labels with an Excel Doc Containing Sku # and Sku Description

All-
I have an Excel file with 2 columns (Sku # and Sku Description).

Is it possible to add this list into the Word document without doing it manually?

Thank you,
Jay
Attached Files
File Type: xlsx Skus.xlsx (17.8 KB, 3 views)
File Type: docx Template.docx (16.6 KB, 3 views)
Reply With Quote
  #2  
Old 02-16-2021, 09:45 PM
macropod's Avatar
macropod macropod is online now Creating labels with an Excel Doc Containing Sku # and Sku Description Windows 10 Creating labels with an Excel Doc Containing Sku # and Sku Description Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,100
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

All you need for that is a label merge. See:
Use mail merge for bulk email, letters, labels, and envelopes - Office Support
Print labels for your mailing list - Office Support
Video: Create labels with a mail merge in Word - Office Support
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 02-16-2021, 09:49 PM
gmayor's Avatar
gmayor gmayor is offline Creating labels with an Excel Doc Containing Sku # and Sku Description Windows 10 Creating labels with an Excel Doc Containing Sku # and Sku Description Office 2019
Expert
 
Join Date: Aug 2014
Posts: 3,429
gmayor is a name known to allgmayor is a name known to allgmayor is a name known to allgmayor is a name known to allgmayor is a name known to allgmayor is a name known to all
Default

It's relatively simple to use a labels or letter merge to achieve that. See attached.
Attached Files
File Type: docx Template (Modified).docx (14.0 KB, 1 views)
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #4  
Old 02-17-2021, 09:30 AM
Jay Chang Jay Chang is offline Creating labels with an Excel Doc Containing Sku # and Sku Description Windows 10 Creating labels with an Excel Doc Containing Sku # and Sku Description Office 2019
Novice
Creating labels with an Excel Doc Containing Sku # and Sku Description
 
Join Date: Feb 2021
Posts: 2
Jay Chang is on a distinguished road
Default

Thanks for the tips everyone! Appreciate the help.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
creating multiple data rows, for labels based on a cell value josbor01 Excel Programming 3 01-02-2018 02:04 PM
Creating labels with an Excel Doc Containing Sku # and Sku Description Difficulty creating labels with Avery 22804 template dijear Word 2 10-25-2017 11:40 AM
Creating labels with an Excel Doc Containing Sku # and Sku Description Labels from excel spreadsheet Shepherdra Mail Merge 5 12-11-2014 11:26 PM
Creating labels with an Excel Doc Containing Sku # and Sku Description import labels from excel tactical Mail Merge 3 05-29-2012 04:03 PM
Creating mailing labels from list in excel wordnoob2 Mail Merge 0 12-13-2010 03:46 PM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 05:31 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft