#1
|
|||
|
|||
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? |
#2
|
||||
|
||||
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] |
#3
|
|||
|
|||
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.
|
#4
|
||||
|
||||
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] |
#5
|
|||
|
|||
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.
|
#6
|
||||
|
||||
Quote:
Quote:
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] |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Slow Moving Excel Spreadsheet.. | kiersten | Excel | 3 | 09-09-2014 03:03 AM |
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 |