Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge in Office Word 2007 - Labels
I need to use at least 4 lines for the address, sometimes more. For instance
there may be Address 1, 2, 3 and sometimes I have a PO Box in which case there is no need for Address 1 and 2, etc. My label is big enough, but due to default line spacing in Word I cannot fit all the Address lines on the label without losing the city and state and zip. Also, how can I elminate Address 1 & 2 if I have a PO Box line. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge in Office Word 2007 - Labels
For the first part, modify the line spacing in the paragraph format of the
labels What is the name of the field that may contain the PO Box? -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Jax" wrote in message ... I need to use at least 4 lines for the address, sometimes more. For instance there may be Address 1, 2, 3 and sometimes I have a PO Box in which case there is no need for Address 1 and 2, etc. My label is big enough, but due to default line spacing in Word I cannot fit all the Address lines on the label without losing the city and state and zip. Also, how can I elminate Address 1 & 2 if I have a PO Box line. |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge in Office Word 2007 - Labels
The name of the PO Box field is "PO Box"
"Doug Robbins - Word MVP" wrote: For the first part, modify the line spacing in the paragraph format of the labels What is the name of the field that may contain the PO Box? -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Jax" wrote in message ... I need to use at least 4 lines for the address, sometimes more. For instance there may be Address 1, 2, 3 and sometimes I have a PO Box in which case there is no need for Address 1 and 2, etc. My label is big enough, but due to default line spacing in Word I cannot fit all the Address lines on the label without losing the city and state and zip. Also, how can I elminate Address 1 & 2 if I have a PO Box line. |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge in Office Word 2007 - Labels
I need to insert another field for the POB. For instance, I don't need
country, so I can move everything down a bit to make room for the POB address and I prefer to have a condition that says if there is a PO Box field greater than or equal to 0, then address fields 1 & 2 do not apply. Those fields may be filled in on the data base because, in our data base, we need to have the physical address as well. "Jax" wrote: The name of the PO Box field is "PO Box" "Doug Robbins - Word MVP" wrote: For the first part, modify the line spacing in the paragraph format of the labels What is the name of the field that may contain the PO Box? -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Jax" wrote in message ... I need to use at least 4 lines for the address, sometimes more. For instance there may be Address 1, 2, 3 and sometimes I have a PO Box in which case there is no need for Address 1 and 2, etc. My label is big enough, but due to default line spacing in Word I cannot fit all the Address lines on the label without losing the city and state and zip. Also, how can I elminate Address 1 & 2 if I have a PO Box line. |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge in Office Word 2007 - Labels
Do it the other way round ie insert the fields only when the condition is
met {IF {Mergefield "PO Box"} = 0 "{Mergefield Addr1} {Mergefield Addr2}"} "PO Box" will have to contain only a number -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Jax wrote: I need to insert another field for the POB. For instance, I don't need country, so I can move everything down a bit to make room for the POB address and I prefer to have a condition that says if there is a PO Box field greater than or equal to 0, then address fields 1 & 2 do not apply. Those fields may be filled in on the data base because, in our data base, we need to have the physical address as well. "Jax" wrote: The name of the PO Box field is "PO Box" "Doug Robbins - Word MVP" wrote: For the first part, modify the line spacing in the paragraph format of the labels What is the name of the field that may contain the PO Box? -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Jax" wrote in message ... I need to use at least 4 lines for the address, sometimes more. For instance there may be Address 1, 2, 3 and sometimes I have a PO Box in which case there is no need for Address 1 and 2, etc. My label is big enough, but due to default line spacing in Word I cannot fit all the Address lines on the label without losing the city and state and zip. Also, how can I elminate Address 1 & 2 if I have a PO Box line. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Office 2000 mail merge to labels | Mailmerge | |||
mail merge 2007 word labels | Mailmerge | |||
Mail Merge Labels (Word 2007) w/ Excel (2007) | Microsoft Word Help | |||
Mail Merge Labels (Word 2007) from Excel (2007) | Microsoft Word Help | |||
Mail Merge Labels in Word 2007 | Formatting Long Documents |