Group:  Microsoft Word ยป microsoft.public.word.mailmerge.fields
Thread: Mail Merge in Office Word 2007 - Labels

Geek News

Mail Merge in Office Word 2007 - Labels
Jax 12/8/2008 9:04:02 PM
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.
Re: Mail Merge in Office Word 2007 - Labels
"Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 12/9/2008 3:57:18 AM
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.


Re: Mail Merge in Office Word 2007 - Labels
Jax 12/9/2008 1:50:12 PM
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.
>
>
>
Re: Mail Merge in Office Word 2007 - Labels
Jax 12/9/2008 5:16:26 PM
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.
> >
> >
> >
Re: Mail Merge in Office Word 2007 - Labels
"Graham Mayor" <gmayor[ at ]REMOVETHISmvps.org> 12/10/2008 7:11:15 AM
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.


Home | Search | Terms | Imprint Contact
Newsgroups Reader - provided by WiredBox.Net