Go Back   Tech Support Forum > Microsoft Support > Microsoft Office support

User Tag List

MS Word Mail Merge To Labels From Excel

This is a discussion on MS Word Mail Merge To Labels From Excel within the Microsoft Office support forums, part of the Tech Support Forum category. I'm struggling to generate a document in word of labels from data in an Excel spreadsheet. I am familiar with


Like Tree1Likes
  • 1 Post By macropod
Reply
 
Thread Tools Search this Thread
Old 12-05-2019, 06:06 AM   #1
TSF Enthusiast
 
tomohawk's Avatar
 
Join Date: Dec 2009
Location: Dublin, Ireland
Posts: 1,241
OS: Windows 10 Pro (64-bit)



I'm struggling to generate a document in word of labels from data in an Excel spreadsheet. I am familiar with the whole process (I've created my custom labels etc.), but there used to be an option to merge to new document. Now that is gone and the only option is "Finish & Merge/Edit Individual Documents" or Finish and Print.

When I finish and merge and print, I get a single label per page (my labels are 2 x 7 per page).

I want to create a Word document of all the labels before I proceed to print, so that I can carry out minor edits.

I even tried using the wizard with same results.

I can't find an up-to-date guide to this.

What am I missing?

Tommy
tomohawk is offline   Reply With Quote
Sponsored Links
Advertisement
 
Old 12-05-2019, 01:11 PM   #2
Moderator
- Microsoft Support
Microsoft MVP
 
macropod's Avatar

Microsoft Most Valuable Professional
 
Join Date: Apr 2008
Location: Australia
Posts: 2,523
OS: Win 7 (64-bit)



Your description suggests you have the mailmerge configured for letters instead of for labels. See under mailings>Start Mail Merge.
tomohawk likes this.
__________________


Cheers,
Paul Edstein
(Fmr MS MVP - Word)
macropod is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is on
Smilies are on
[IMG] code is on
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Post a Question


» Site Navigation
 > FAQ
  > 10.0.0.2
Powered by vBadvanced CMPS v3.2.3


All times are GMT -7. The time now is 06:53 AM.


Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2020, vBulletin Solutions, Inc.
vBulletin Security provided by vBSecurity v2.2.2 (Pro) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging v3.1.0 (Pro) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
Copyright 2001 - 2018, Tech Support Forum

Windows 10 - Windows 7 - Windows XP - Windows Vista - Trojan Removal - Spyware Removal - Virus Removal - Networking - Security - Top Web Hosts