Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
jax jax is offline
external usenet poster
 
Posts: 27
Default 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   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default 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   Report Post  
Posted to microsoft.public.word.mailmerge.fields
jax jax is offline
external usenet poster
 
Posts: 27
Default 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   Report Post  
Posted to microsoft.public.word.mailmerge.fields
jax jax is offline
external usenet poster
 
Posts: 27
Default 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   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default 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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Office 2000 mail merge to labels bozzer Mailmerge 5 January 27th 09 01:24 PM
mail merge 2007 word labels GPCHS Mailmerge 1 October 7th 08 08:28 PM
Mail Merge Labels (Word 2007) w/ Excel (2007) aedcone Microsoft Word Help 2 August 11th 08 03:14 PM
Mail Merge Labels (Word 2007) from Excel (2007) aedcone Microsoft Word Help 3 August 8th 08 03:29 PM
Mail Merge Labels in Word 2007 Dennis Hughes Formatting Long Documents 8 March 29th 07 09:37 PM


All times are GMT +1. The time now is 06:37 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"