|
|
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.
|
|
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" <Jax[ at ]discussions.microsoft.com> wrote in message news:AD7AFE93-1D06-468C-888B-8399C26CDE21[ at ]microsoft.com...
[Quoted Text] >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.
|
|
The name of the PO Box field is "PO Box"
"Doug Robbins - Word MVP" wrote:
[Quoted Text] > 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" <Jax[ at ]discussions.microsoft.com> wrote in message > news:AD7AFE93-1D06-468C-888B-8399C26CDE21[ at ]microsoft.com... > >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. > > >
|
|
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:
[Quoted Text] > 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" <Jax[ at ]discussions.microsoft.com> wrote in message > > news:AD7AFE93-1D06-468C-888B-8399C26CDE21[ at ]microsoft.com... > > >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. > > > > > >
|
|
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:
[Quoted Text] > 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" <Jax[ at ]discussions.microsoft.com> wrote in message >>> news:AD7AFE93-1D06-468C-888B-8399C26CDE21[ at ]microsoft.com... >>>> 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.
|
|
|