Creating Labels Over 3-Up Image


Joined
Jul 24, 2017
Messages
2
Reaction score
0
Hi,

I'm pulling my hair out trying to do something that should be simple, but is turning out to be difficult. I have these name badges I need to create that are white with a blue logo on top. I included a sample (with the logos blurred out) to give you a visual.

3bTa3
https://ibb.co/cSs3H5

Basically, I'm trying to mail merge an excel list to have people's names and companies on these badges. Usually I make these 1 per page, which is easy, because I can just use a text box and center everything. But these are small enough for me to do 3-up, which means I can't use a text box because it does not allow you to use <<Next Record>>. It would be so much simpler if I could use a text box, but I can't, and I'm told to use tables to do this. The problem is, I cannot for the life of me get the table to fit right. This is how I've been trying to do this:

1. I insert the JPG of the 3-up name badges.
2. I set the positioning behind text, and then adjust the position to be center-aligned vertically and horizontally.
3. Create a table (either 1 x 3 or 1 x 6 .... see below) where the cells cover the white parts of the badges.
4. Insert the fields to be centered in the white parts of the badges.

I've tried to make a 1 column x 3 row table (with the cells split apart so they only fill the white part) and center the merge fields in there, but no matter how much I play with the positioning and the text wrapping, the table just won't cooperate with the image. I've also tried making a 1 column by 6 row, just in case you cant have cells distanced apart from each other. For example, I've tried making empty cells cover the blue part of the name badge and not filling it in anything, and then putting the fields in the white parts (with the next record fields in the 4th and 6th cells).

Basically, if I use text boxes, I can easily fill the white parts on the image, and have text that is center-aligned to the text box dimensions. Unfortunately, this makes doing 3-up impossible because I can't use <<Next Record>> in text boxes. But instead I am trying to use tables as is recommended. I have to keep resizing the height of the cells, and they never want to match up with the picture which I have placed behind the text. I can get some of the cells sized right, but then there's usually one that's not sized correctly, and then when I try to adjust that one, the other ones change... it's just a nightmare all around. Not to mention trying to select between the table and the image in Word is incredibly difficult, as it's always trying to select the wrong thing.
 

Attachments

  • sample.jpg
    sample.jpg
    25.3 KB · Views: 344
Ad

Advertisements

Joined
Jul 24, 2017
Messages
2
Reaction score
0
When I tried making custom labels that match the height and width of the white portion of the picture, and add the the length of the top part to the vertical pitch to separate it, I get something that looks like it will work. I place the picture behind text and drag it over the table. The problem is, when I merge the labels, something crazy happens! It's as if Word wants to print every single page that it creates onto 1 page... I've never seen this before:

https://ibb.co/iq07AQ

I thought maybe it's because of the margins and where the section break occurs, but so I tried reducing the margins to as small as I could, so that the section break didn't occur over the actual labels... but that didn't help.
 
Ad

Advertisements

macropod

Microsoft MVP
Joined
Mar 2, 2012
Messages
521
Reaction score
48
What you need to do is use a 1 column x 3 row table into which you can insert the mergefields, with the images set 'behind text' (not in textboxes) and suitably positioned behind the table. Make sure you're using a label merge and, once you have the first table cell suitably formatted, click on 'update labels' to propagate the setup to the other cells. Finishing (not previewing) the merge should then produce an output document with all the labels - 3 to a page.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top