Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I get rid of extra spaces?
Hi Everyone!
I've completed mail merge labels, and noticed that there is an extra space at the beginning of the last line, which contains the phone numbers. How do I get rid of it without having to go through each label and deleting the space? The extra space occurs when the line that is supposed to contain the phone numbers is void a phone number. For instance, I have set the fields/information to appear this way: Name Address City, State Zip W: _____ H: _______ C: ________ (Work, Home, Cell, respectively) If the person's record does not contain a work number, a blank space, which I assume is the space between the last number of the work phone number and the initial "H" will appear, then the other available phone numbers. I have to place a blank space between the fields, or the numbers will run together when I perform a merge. Any help will be appreciated. I have Word 2003. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I get rid of extra spaces?
Toody,
Have you consider using a table for the phone# line of your label? Create a table with 6 columns & 1 line. Or two columns for every type of phone# you want to show. So if you want the three types in your example: 1. In the Odd columns, type in "W: ", "H: ", "C:", etc... (without the quotes). 2. In the Even Columns, insert mergefields for the phone# data from your data source file. 3. Then add a borderline to the bottom of the column box just under the Phone# mergefield. -- Have A Good Day Rich/rerat Add MS to your News Reader: news://msnews.microsoft.com (RRR News) message rule Previous Text Snipped to Save Bandwidth When Appropriate "Toody" wrote in message ... Hi Everyone! I've completed mail merge labels, and noticed that there is an extra space at the beginning of the last line, which contains the phone numbers. How do I get rid of it without having to go through each label and deleting the space? The extra space occurs when the line that is supposed to contain the phone numbers is void a phone number. For instance, I have set the fields/information to appear this way: Name Address City, State Zip W: _____ H: _______ C: ________ (Work, Home, Cell, respectively) If the person's record does not contain a work number, a blank space, which I assume is the space between the last number of the work phone number and the initial "H" will appear, then the other available phone numbers. I have to place a blank space between the fields, or the numbers will run together when I perform a merge. Any help will be appreciated. I have Word 2003. |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I get rid of extra spaces?
I don't know what fields you have at the moment but if you just want
whatever numbers are non-blank, one after the other, you could try { MERGEFIELD Workphone \b "W: " \f " " }{ MERGEFIELD Homephone \b "H: " \f " " }{ MERGEFIELD Cellphone \b "W: " \f " " } Use e.g. ctrl-F9 to insert the special field code braces {} as necessary, and substitute your own field names. -- Peter Jamieson http://tips.pjmsn.me.uk "Toody" wrote in message ... Hi Everyone! I've completed mail merge labels, and noticed that there is an extra space at the beginning of the last line, which contains the phone numbers. How do I get rid of it without having to go through each label and deleting the space? The extra space occurs when the line that is supposed to contain the phone numbers is void a phone number. For instance, I have set the fields/information to appear this way: Name Address City, State Zip W: _____ H: _______ C: ________ (Work, Home, Cell, respectively) If the person's record does not contain a work number, a blank space, which I assume is the space between the last number of the work phone number and the initial "H" will appear, then the other available phone numbers. I have to place a blank space between the fields, or the numbers will run together when I perform a merge. Any help will be appreciated. I have Word 2003. |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I get rid of extra spaces?
Thanks to both of you. I will give them a try! (It's so nice to have options!!)
"Peter Jamieson" wrote: I don't know what fields you have at the moment but if you just want whatever numbers are non-blank, one after the other, you could try { MERGEFIELD Workphone \b "W: " \f " " }{ MERGEFIELD Homephone \b "H: " \f " " }{ MERGEFIELD Cellphone \b "W: " \f " " } Use e.g. ctrl-F9 to insert the special field code braces {} as necessary, and substitute your own field names. -- Peter Jamieson http://tips.pjmsn.me.uk "Toody" wrote in message ... Hi Everyone! I've completed mail merge labels, and noticed that there is an extra space at the beginning of the last line, which contains the phone numbers. How do I get rid of it without having to go through each label and deleting the space? The extra space occurs when the line that is supposed to contain the phone numbers is void a phone number. For instance, I have set the fields/information to appear this way: Name Address City, State Zip W: _____ H: _______ C: ________ (Work, Home, Cell, respectively) If the person's record does not contain a work number, a blank space, which I assume is the space between the last number of the work phone number and the initial "H" will appear, then the other available phone numbers. I have to place a blank space between the fields, or the numbers will run together when I perform a merge. Any help will be appreciated. I have Word 2003. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extra Spaces in my Mail Merge | Mailmerge | |||
Deleting extra line spaces | Microsoft Word Help | |||
Removing extra spaces between words | Microsoft Word Help | |||
how do get I rid of the extra spaces between sentences | Microsoft Word Help | |||
How do I get rid of extra spaces in footnotes? | Microsoft Word Help |