Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-10-2020, 02:22 PM
Involute Involute is offline Mail Merge is appending blank label to every legit label Windows 10 Mail Merge is appending blank label to every legit label Office 2019
Novice
Mail Merge is appending blank label to every legit label
 
Join Date: Dec 2020
Posts: 2
Involute is on a distinguished road
Default Mail Merge is appending blank label to every legit label


I've created a mail merge document drawing data from an Excel spreadsheet and merging to address labels to be printed from a Brother label printer. Everything formats and prints fine, except Word is appending a blank label to every record, as you can see in the attachment, which would cause me to waste a lot of labels if I proceeded with this. I'm unable to delete the paragraph mark on the blank label. I thought this might have something to do with the table layout, but I haven't been able to find any table formatting tools to play with. I used the Mail Merge Wizard to set this up. Thanks for any tips.
Attached Images
File Type: jpg Label.jpg (52.3 KB, 7 views)
Reply With Quote
  #2  
Old 12-11-2020, 08:43 PM
macropod's Avatar
macropod macropod is offline Mail Merge is appending blank label to every legit label Windows 10 Mail Merge is appending blank label to every legit label Office 2010
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 20,702
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

It's impossible to tell from your attachment what the issue is.

Without actually seeing the mailmerge main document, it can be difficult for anyone to diagnose the issue. Can you attach that document to a post (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
  #3  
Old 12-11-2020, 08:52 PM
Involute Involute is offline Mail Merge is appending blank label to every legit label Windows 10 Mail Merge is appending blank label to every legit label Office 2019
Novice
Mail Merge is appending blank label to every legit label
 
Join Date: Dec 2020
Posts: 2
Involute is on a distinguished road
Default

In spite of showing an extra label Word only printed the first one, which is what I wanted, so problem solved, I guess.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge is appending blank label to every legit label Sticky Label mail merge jcaswell Mail Merge 4 11-30-2020 04:16 PM
pleasse help mail merge label formats briffdogg Mail Merge 2 04-21-2018 07:23 AM
Mail Merge is appending blank label to every legit label Label Mail Merge Costco25 Mail Merge 1 12-01-2016 03:25 PM
Mail Merge is appending blank label to every legit label Editing a mail merge label Colonel Biggs Word 6 03-22-2015 07:09 AM
Mail Merge is appending blank label to every legit label How to start a label mail merge at a specific label? DHKaplan Mail Merge 2 04-17-2014 07:33 PM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 08:28 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