Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-11-2014, 04:16 PM
Shepherdra Shepherdra is offline Labels from excel spreadsheet Windows 7 64bit Labels from excel spreadsheet Office 2007
Novice
Labels from excel spreadsheet
 
Join Date: Dec 2014
Posts: 3
Shepherdra is on a distinguished road
Default Labels from excel spreadsheet


I have all my addresses in an excel spreadsheet. I follow all the directions in the help menus to make mailing labels. However, everytime I bring up the mail recipient list after going through the merge steps, it give me 77 pages and not 77 labels. Each page drops off the first name until the last page is left with one name. How do I get it to give me three pages, one name on each label?
Reply With Quote
  #2  
Old 12-11-2014, 05:34 PM
macropod's Avatar
macropod macropod is offline Labels from excel spreadsheet Windows 7 64bit Labels from excel spreadsheet Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

That suggests you aren't using a label merge and/or you haven't used the 'update labels' function after preparing the first label.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 12-11-2014, 06:21 PM
Shepherdra Shepherdra is offline Labels from excel spreadsheet Windows 7 64bit Labels from excel spreadsheet Office 2007
Novice
Labels from excel spreadsheet
 
Join Date: Dec 2014
Posts: 3
Shepherdra is on a distinguished road
Default

Your response suggests you didnt read my input. I have followed 18 pages of instructions to the letter and still get the 77 pages and not the 77 labels. I need help from someone who is suggestive.
Reply With Quote
  #4  
Old 12-11-2014, 06:30 PM
macropod's Avatar
macropod macropod is offline Labels from excel spreadsheet Windows 7 64bit Labels from excel spreadsheet Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

If that's the best you can do, I suggest you don't bother asking for help. I've been using Word for decades and am thoroughly conversant with how mailmerge works. I've even published mailmerge tutorials (e.g. http://windowssecrets.com/forums/sho...merge-Tutorial) and the Mailmerge Tips & Tricks in the 'Sticky' thread at the top of this forum (https://www.msofficeforums.com/mail-...ps-tricks.html). A label merge requires no more than a single page of instructions (not even that if you use the mailmerge wizard), not 18... Clearly you are not following the correct instructions or, if you are, you're not following them correctly. My previous response identified the most likely sources of user error.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 12-11-2014, 11:17 PM
Shepherdra Shepherdra is offline Labels from excel spreadsheet Windows 7 64bit Labels from excel spreadsheet Office 2007
Novice
Labels from excel spreadsheet
 
Join Date: Dec 2014
Posts: 3
Shepherdra is on a distinguished road
Default

I also have been using word for several decades and am familiar with the mail merge program, and you are correct, it should only take a few keystrokes, However, in this instance the few keystrokes gives me 77 pages and not 77 labels. I just assumed someone would be able to explain to me why that happens and not try to make me feel like a jerk when I have been using the office programs for nearly 20 years. Perhaps you could elaborate a little instead of slamming my computer knowledge.
Reply With Quote
  #6  
Old 12-11-2014, 11:26 PM
macropod's Avatar
macropod macropod is offline Labels from excel spreadsheet Windows 7 64bit Labels from excel spreadsheet Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by Shepherdra View Post
I just assumed someone would be able to explain to me why that happens and not try to make me feel like a jerk
And I gave you the most likely causes of the problem. No-one was trying to make you feel like a jerk - comments like:
Quote:
Your response suggests you didnt read my input.
in your previous response, shows you're happy to imply others are, though.

Assuming you have followed essentially the correct process, then without actually seeing the problem mailmerge main document it can be difficult for anyone to diagnose the issue. Can you attach the document to a post with a representative sample of the Excel data(delete anything sensitive)? You do this via the paperclip symbol on the 'Go Advanced' tab at the bottom of this screen.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Labels from excel spreadsheet Slow Moving Excel Spreadsheet.. kiersten Excel 3 09-09-2014 03:03 AM
Labels from excel spreadsheet Inserting excel spreadsheet into word doc educpara58 Excel 2 07-28-2011 01:22 AM
How do I export my contacts to an Excel spreadsheet? Shawn76 Outlook 2 05-22-2010 07:54 AM
Auditing on Excel and Spreadsheet documents paulmills Office 0 12-08-2009 01:13 PM
How do I use an Excel form to populate and Excel spreadsheet apostht Excel 0 05-21-2006 11:17 AM

Other Forums: Access Forums

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


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