Word Mail Merge Labels: Formatting
BB-
Posted messages
51
Status
Membre
-
Wiwi_12 Posted messages 19 Status Membre -
Wiwi_12 Posted messages 19 Status Membre -
Hello,
I have a quick question regarding the layout of a mail merge for labels created in Word.
Let's say we have created a mail merge to generate labels containing the fields: title, first name, last name, address 1, address 2, address 3, postal code, city, country.
In my database, sometimes I will have content for address 2 and 3, sometimes not. Therefore, we will not have the same number of filled lines for each label. However, I want the content of each of my labels to be vertically centered regardless of the number of lines, for aesthetic reasons.
I have tried to set each of my labels to center vertically... The result is that at the end of the merge, nothing is vertically centered. Everything appears as if I requested a vertical "top" alignment... I know this problem arises because the centering is based on my merge fields, which sometimes have more entries than the information to be written.
Does anyone have a tip?
Thank you very much in advance.
I have a quick question regarding the layout of a mail merge for labels created in Word.
Let's say we have created a mail merge to generate labels containing the fields: title, first name, last name, address 1, address 2, address 3, postal code, city, country.
In my database, sometimes I will have content for address 2 and 3, sometimes not. Therefore, we will not have the same number of filled lines for each label. However, I want the content of each of my labels to be vertically centered regardless of the number of lines, for aesthetic reasons.
I have tried to set each of my labels to center vertically... The result is that at the end of the merge, nothing is vertically centered. Everything appears as if I requested a vertical "top" alignment... I know this problem arises because the centering is based on my merge fields, which sometimes have more entries than the information to be written.
Does anyone have a tip?
Thank you very much in advance.
Configuration: Windows XP Internet Explorer 6.0
11 réponses
Hello
it seems to me that creating labels ultimately gives a table with invisible borders but still a table, so logically we should select the table and center it for all cells
as we can do with a classic table in Word (2003 or 2007)
--
(_Usul of Arrakis
Serial_Dreamer_)
it seems to me that creating labels ultimately gives a table with invisible borders but still a table, so logically we should select the table and center it for all cells
as we can do with a classic table in Word (2003 or 2007)
--
(_Usul of Arrakis
Serial_Dreamer_)
No, if you select the whole table (small cross at the top left of the table when you move the cursor)
then right click / table properties / "cells" tab / and in "vertical alignment click on "center"
you apply the formatting to all the cells at once
--
(_Usul of Arrakis
Serial_Dreamer_)
then right click / table properties / "cells" tab / and in "vertical alignment click on "center"
you apply the formatting to all the cells at once
--
(_Usul of Arrakis
Serial_Dreamer_)
Have you looked in "table properties" / "table" tab / "options" button / there you can adjust the internal margins of the cells, that might be where you'll find the solution for your layout
--
(_Usul of Arrakis
Serial_Dreamer_)
--
(_Usul of Arrakis
Serial_Dreamer_)
Hello Argixu,
thank you very much for your response, I tried your method but it doesn’t change the final result. My content is still not centered vertically. I think your method should only be used if we have "empty lines" in the merge, right?
But actually, if I don't have anything for "address2", "address3", or another field, my merge doesn't leave me an empty line.
For example, I get (I’m using fictitious names and addresses here):
Mr. Alain Dupont
2 rue de la Haie
72220 Le Mans
Otherwise, I can also get:
Mrs. Françoise Durant
Lotissement La Roseraie
43 avenue de l'Hirondelle
75011 Paris
No matter how many lines, I still get a "block" without any insertion of empty lines.
What I'm looking for is a solution to ensure that this "block" is centered vertically regardless of the number of filled lines.
Thank you very much.
thank you very much for your response, I tried your method but it doesn’t change the final result. My content is still not centered vertically. I think your method should only be used if we have "empty lines" in the merge, right?
But actually, if I don't have anything for "address2", "address3", or another field, my merge doesn't leave me an empty line.
For example, I get (I’m using fictitious names and addresses here):
Mr. Alain Dupont
2 rue de la Haie
72220 Le Mans
Otherwise, I can also get:
Mrs. Françoise Durant
Lotissement La Roseraie
43 avenue de l'Hirondelle
75011 Paris
No matter how many lines, I still get a "block" without any insertion of empty lines.
What I'm looking for is a solution to ensure that this "block" is centered vertically regardless of the number of filled lines.
Thank you very much.
Good evening BB,
Yes, it was to avoid empty lines, so that you always have the same number of lines, more aesthetically pleasing for vertical alignment. But I didn’t see in your first message the “regardless of the number of lines” Sorry :)
But now, the vertical alignment and margin options in the cells that were given to you should automatically align the content.
Try this: delete the paragraph after the last field, so that there is only the symbol (square) of the cell
---Argitxu
Yes, it was to avoid empty lines, so that you always have the same number of lines, more aesthetically pleasing for vertical alignment. But I didn’t see in your first message the “regardless of the number of lines” Sorry :)
But now, the vertical alignment and margin options in the cells that were given to you should automatically align the content.
Try this: delete the paragraph after the last field, so that there is only the symbol (square) of the cell
---Argitxu
Hello,
if you are working in Word 2007!
menu Mailings/Start Mail Merge/Labels/Details/the Label Options window opens
and it's up to you to choose the options you want.
if you are working in Word 2007!
menu Mailings/Start Mail Merge/Labels/Details/the Label Options window opens
and it's up to you to choose the options you want.
Hello,
thank you smartway for the procedure in Word 2007, I will remember it if it happens to me in the future. For now, I'm working on Word 2003.
Thanks everyone for your responses and have a great day.
thank you smartway for the procedure in Word 2007, I will remember it if it happens to me in the future. For now, I'm working on Word 2003.
Thanks everyone for your responses and have a great day.
Hello UrsulArrakis,
yes indeed, in the end we get a table created in Word and once the merge is done, we can reformat each label, which is an option when you have few. I will have about 400 and I won’t have the time to redo the layout on each label. Too bad, I’ll leave it like that...
Thanks again.
yes indeed, in the end we get a table created in Word and once the merge is done, we can reformat each label, which is an option when you have few. I will have about 400 and I won’t have the time to redo the layout on each label. Too bad, I’ll leave it like that...
Thanks again.
Yes, I used this method as well, but it’s still not very well centered; let’s say it’s rather approximate. You can feel that there’s “space” in the labels that isn’t taken into account for centering.
Probably because it’s not an ordinary table but a table containing merged fields.
But I’ll make do with it.
Thanks again.
Probably because it’s not an ordinary table but a table containing merged fields.
But I’ll make do with it.
Thanks again.
Yes, I know the options offered by the properties of a table in Word, but I can't use them for a merge like the one I have to do. Indeed, if I specify internal margins, for example, this will apply to all labels. However, each label will not have the same number of characters per line, so I risk sometimes (when I have very long names, for example) having my "title" + "first name" + "last name" on two lines instead of one, and that would be an additional issue for the rest of my label.
I just wanted to know if there is a "special mail merge" trick, but apparently there isn't, or maybe through a macro, but I'm not familiar with those. So I will stick with it like this.
But again, thank you for your help.
I just wanted to know if there is a "special mail merge" trick, but apparently there isn't, or maybe through a macro, but I'm not familiar with those. So I will stick with it like this.
But again, thank you for your help.
To center the text vertically on labels in Word:
1) Ctrl + A (on the entire table)
2) Right-click on the small square (with the 4 arrows) in the first cell at the top left
3) "Table properties..."
4) "Cell" tab
5) Select the vertical alignment "Centered" then "OK".
Enjoy.
1) Ctrl + A (on the entire table)
2) Right-click on the small square (with the 4 arrows) in the first cell at the top left
3) "Table properties..."
4) "Cell" tab
5) Select the vertical alignment "Centered" then "OK".
Enjoy.
Good evening,
Use the Insert a keyword if...then...else... function.
On the first label,
- if the field name: address2 is empty… "you compare" to nothing…
- then …"Insert the following text" you put nothing
- Else… "this one"… type: address2 and validate
Press ALT + F9 to display the field codes:
on the first label, select "address2" at the end (including quotes), and press CTRL + F9 to enclose it in braces which will give it the value of a field.
Then copy this line to the second label. Copy/paste the second label onto all the others
And then do the merge.
The line will not display anything if there is nothing, otherwise it will show the found address
PS: do not put spaces in the field names of the Excel file
--
Argitxu
Use the Insert a keyword if...then...else... function.
On the first label,
- if the field name: address2 is empty… "you compare" to nothing…
- then …"Insert the following text" you put nothing
- Else… "this one"… type: address2 and validate
Press ALT + F9 to display the field codes:
on the first label, select "address2" at the end (including quotes), and press CTRL + F9 to enclose it in braces which will give it the value of a field.
Then copy this line to the second label. Copy/paste the second label onto all the others
And then do the merge.
The line will not display anything if there is nothing, otherwise it will show the found address
PS: do not put spaces in the field names of the Excel file
--
Argitxu