Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-27-2016, 12:27 PM
cawphoenix cawphoenix is offline Word Merge - Labels - specific spacing Windows XP Word Merge - Labels - specific spacing Office 2003
Novice
Word Merge - Labels - specific spacing
 
Join Date: Jan 2016
Posts: 4
cawphoenix is on a distinguished road
Default Word Merge - Labels - specific spacing

I need to create labels that have fields printed in specific places and not be impacted by the length of another field - e.g. name or address. I tried using the CTRL-TAB but it still moves data when another field on the same line has more characters.



Can you add any additional formatting to a label such as a frames or boxes that have the merged data inserted inside the frame or box?
Reply With Quote
  #2  
Old 01-27-2016, 12:34 PM
Charles Kenyon Charles Kenyon is offline Word Merge - Labels - specific spacing Windows 8 Word Merge - Labels - specific spacing Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,155
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Labels are tables. You can do anything with a label format that you can do in a table.
You could split the cell into multiple cells and put different merge fields in different cells. I'm afraid the merge wizard would not be of much help doing this.

Create a page of the labels you would use. Then modify them so they have additional cells and populate with your merge fields.
Reply With Quote
  #3  
Old 01-27-2016, 12:44 PM
thakuri.neelam5 thakuri.neelam5 is offline Word Merge - Labels - specific spacing Windows 7 32bit Word Merge - Labels - specific spacing Office 2016
Novice
 
Join Date: Jan 2016
Posts: 1
thakuri.neelam5 is on a distinguished road
Default

Try adding building block into text boxes. Draw a text box. Go to Developer Tab. In the Controls Pane, there is a Building Block Gallery Content Control Button. Clicking that will insert a field in the cursor position. This should help!
Reply With Quote
  #4  
Old 01-27-2016, 01:06 PM
cawphoenix cawphoenix is offline Word Merge - Labels - specific spacing Windows XP Word Merge - Labels - specific spacing Office 2003
Novice
Word Merge - Labels - specific spacing
 
Join Date: Jan 2016
Posts: 4
cawphoenix is on a distinguished road
Default

This was very helpful. Thanks.
I have created the tables and used the word merge to bring in the fields from Excel.
If there is no data in a specific table row, the blank row does not print and the spacing is off. How do I force blank data into a table cell?
Reply With Quote
  #5  
Old 01-27-2016, 01:16 PM
Charles Kenyon Charles Kenyon is offline Word Merge - Labels - specific spacing Windows 8 Word Merge - Labels - specific spacing Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,155
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Quote:
Originally Posted by thakuri.neelam5 View Post
Try adding building block into text boxes. Draw a text box. Go to Developer Tab. In the Controls Pane, there is a Building Block Gallery Content Control Button. Clicking that will insert a field in the cursor position. This should help!
In Word 2003 he has neither building blocks nor content controls.
Reply With Quote
  #6  
Old 01-27-2016, 01:21 PM
Charles Kenyon Charles Kenyon is offline Word Merge - Labels - specific spacing Windows 8 Word Merge - Labels - specific spacing Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,155
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Quote:
Originally Posted by cawphoenix View Post
This was very helpful. Thanks.
I have created the tables and used the word merge to bring in the fields from Excel.
If there is no data in a specific table row, the blank row does not print and the spacing is off. How do I force blank data into a table cell?
I am assuming you are responding to me.
I would have to do this without the merge wizard by simply attaching the current document (labels) to the data under mailings. I would then populate each cell by hand.

Often to do this, I will use a blank unformatted document (not labels) to create my basic cell content (which when displayed can be more than a label can hold although the merge works). The last thing in the merge is a next record command. Then I copy that into each cell of the table. In your case, you will actually have multiple cells for each record because each label will actually consist of multiple cells.
Reply With Quote
  #7  
Old 01-27-2016, 01:24 PM
Charles Kenyon Charles Kenyon is offline Word Merge - Labels - specific spacing Windows 8 Word Merge - Labels - specific spacing Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,155
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Quote:
Originally Posted by cawphoenix View Post
This was very helpful. Thanks.
I have created the tables and used the word merge to bring in the fields from Excel.
If there is no data in a specific table row, the blank row does not print and the spacing is off. How do I force blank data into a table cell?
What do you mean the blank row does not print and the spacing is off? Do you have blank rows in your data?

Your label format should be fixed-size cells so the spacing should be the same whether or not there is data.
Reply With Quote
  #8  
Old 01-27-2016, 01:25 PM
cawphoenix cawphoenix is offline Word Merge - Labels - specific spacing Windows XP Word Merge - Labels - specific spacing Office 2003
Novice
Word Merge - Labels - specific spacing
 
Join Date: Jan 2016
Posts: 4
cawphoenix is on a distinguished road
Default

I'm not a developer just a simple Word user! I think I can manage around this spacing problem.
Two more quick Q's:
1. Is there a way to print vertically in a text box?
2. When I complete the merge and select "edit individual labels", it creates a .doc with 1 page an multiple sections. How can I print only selected sections vs. the entire document.

FYI - this forum has been amazing. You have really helped me thru this procedure.
Reply With Quote
  #9  
Old 01-27-2016, 01:49 PM
macropod's Avatar
macropod macropod is offline Word Merge - Labels - specific spacing Windows 7 64bit Word Merge - Labels - specific spacing Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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 Charles Kenyon View Post
Quote:
Originally Posted by thakuri.neelam5 View Post
Try adding building block into text boxes. Draw a text box. Go to Developer Tab. In the Controls Pane, there is a Building Block Gallery Content Control Button. Clicking that will insert a field in the cursor position. This should help!
In Word 2003 he has neither building blocks nor content controls.
Neither do the textboxes work at all in a label mailmerge, so it doesn't matter which version of Word the OP is using.

cawphoenix: As indicated in my comments above, you can't use a text box. If you use individual cells as Charles suggested - but which will also be a lot of work to set up - you can rotate text to print vertically in a table cell. As for the print issue, you could merge just the records you're interested in, or you could print just the Sections of the output you want to print.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #10  
Old 01-27-2016, 01:52 PM
cawphoenix cawphoenix is offline Word Merge - Labels - specific spacing Windows XP Word Merge - Labels - specific spacing Office 2003
Novice
Word Merge - Labels - specific spacing
 
Join Date: Jan 2016
Posts: 4
cawphoenix is on a distinguished road
Default

Got it. Thanks. I'll give that a try. You've been a great help.
Reply With Quote
Reply

Tags
labels print spacing



Similar Threads
Thread Thread Starter Forum Replies Last Post
Word Merge - Labels - specific spacing Labels are not printed the way they are shown on the screen! (Word 2013 via Mail Merge) malinneedshelp Mail Merge 2 12-09-2014 03:08 AM
Double Line Spacing in Word 2010 address merge Chevydean Word 1 09-15-2013 11:51 AM
Word Merge - Labels - specific spacing Insert picture background in Word mail merge labels obasanla Mail Merge 6 11-26-2012 11:53 PM
Word Merge - Labels - specific spacing Labels not spacing correctly from Word on Canon i950 HitchGeneva Word 2 06-06-2011 04:02 AM
word 2003 mail merge labels? JoeGrapes Mail Merge 0 04-20-2009 12:43 PM

Other Forums: Access Forums

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