Blank Line in Mail Merge Address Labels

Help please….I am getting a blank line in some of my address labels. I use
Outlook 2003 and have a defined view of Christmas Cards. I then use the
Outlook merge facility and when prompted set up my labels in Word 2003. Next
I configure an address block and propagate my addresses.

However, when I merge to a new document all addresses with two lines in the
street address field have a blank line between the street address and the
city – see illustration below. Those labels which only have one line in the
street field do not have a blank line.

Haddon
8a Main Street

Timbuktu

All suggestions welcome

"BobRob" wrote in message
...
Help please….I am getting a blank line in some of my address labels. I use
Outlook 2003 and have a defined view of Christmas Cards. I then use the
Outlook merge facility and when prompted set up my labels in Word 2003.
Next
I configure an address block and propagate my addresses.

However, when I merge to a new document all addresses with two lines in
the
street address field have a blank line between the street address and the
city – see illustration below. Those labels which only have one line in
the
street field do not have a blank line.

Haddon
8a Main Street

Timbuktu

All suggestions welcome



I had that - I found I had to edit the addresses in Outlook and put two
address lines in the "Street" box as opposed to just the street.

--
Asking a question?
Please tell us the version of the application you are asking about,
your OS, Service Pack level
and the FULL contents of any error message(s)

Gordon,

Thanks for your suggestion. However I do put two lines in the outlook street
field. Using the example I enter in the street field

Haddon
8a Main Street

Any other suggestions?

"Gordon" wrote:

"BobRob" wrote in message
...
Help please….I am getting a blank line in some of my address labels. I use
Outlook 2003 and have a defined view of Christmas Cards. I then use the
Outlook merge facility and when prompted set up my labels in Word 2003.
Next
I configure an address block and propagate my addresses.

However, when I merge to a new document all addresses with two lines in
the
street address field have a blank line between the street address and the
city – see illustration below. Those labels which only have one line in
the
street field do not have a blank line.

Haddon
8a Main Street

Timbuktu

All suggestions welcome



I had that - I found I had to edit the addresses in Outlook and put two
address lines in the "Street" box as opposed to just the street.

--
Asking a question?
Please tell us the version of the application you are asking about,
your OS, Service Pack level
and the FULL contents of any error message(s)

"BobRob" wrote in message
...
Gordon,

Thanks for your suggestion. However I do put two lines in the outlook
street
field. Using the example I enter in the street field

Haddon
8a Main Street

Any other suggestions?

"Gordon" wrote:

"BobRob" wrote in message
...
Help please….I am getting a blank line in some of my address labels. I
use
Outlook 2003 and have a defined view of Christmas Cards. I then use the
Outlook merge facility and when prompted set up my labels in Word 2003.
Next
I configure an address block and propagate my addresses.

However, when I merge to a new document all addresses with two lines in
the
street address field have a blank line between the street address and
the
city – see illustration below. Those labels which only have one line in
the
street field do not have a blank line.

Haddon
8a Main Street

Timbuktu


I think you have to play with it - I think it depends on how many other
lines are in the address - sorry, that's all I can think of.
--
Asking a question?
Please tell us the version of the application you are asking about,
your OS, Service Pack level
and the FULL contents of any error message(s)

You haven't constructed your merge properly. Do not use derived fields in a
merge. Use the individual address element fields and be sure you follow the
conventions posted here in the "Insert Address" section:
http://www.gmayor.com/Macrobutton.htm

--
Russ Valentine
[MVP-Outlook]
"BobRob" wrote in message
...
Gordon,

Thanks for your suggestion. However I do put two lines in the outlook
street
field. Using the example I enter in the street field

Haddon
8a Main Street

Any other suggestions?

"Gordon" wrote:

"BobRob" wrote in message
...
Help please….I am getting a blank line in some of my address labels. I
use
Outlook 2003 and have a defined view of Christmas Cards. I then use the
Outlook merge facility and when prompted set up my labels in Word 2003.
Next
I configure an address block and propagate my addresses.

However, when I merge to a new document all addresses with two lines in
the
street address field have a blank line between the street address and
the
city – see illustration below. Those labels which only have one line in
the
street field do not have a blank line.

Haddon
8a Main Street

Timbuktu

All suggestions welcome



I had that - I found I had to edit the addresses in Outlook and put two
address lines in the "Street" box as opposed to just the street.

--
Asking a question?
Please tell us the version of the application you are asking about,
your OS, Service Pack level
and the FULL contents of any error message(s)

"Russ Valentine [MVP-Outlook]" wrote in message
...
You haven't constructed your merge properly. Do not use derived fields in
a merge.

So the mailing address is a derived field?

--
Asking a question?
Please tell us the version of the application you are asking about,
your OS, Service Pack level
and the FULL contents of any error message(s)

Yes. Outlook creates it from individual address elements according to the
option you have selected in "This is the Mailing Address"
--
Russ Valentine
[MVP-Outlook]
"Gordon" wrote in message
...
"Russ Valentine [MVP-Outlook]" wrote in message
...
You haven't constructed your merge properly. Do not use derived fields in
a merge.

So the mailing address is a derived field?

--
Asking a question?
Please tell us the version of the application you are asking about,
your OS, Service Pack level
and the FULL contents of any error message(s)

"Russ Valentine [MVP-Outlook]" wrote in message
...
Yes. Outlook creates it from individual address elements according to the
option you have selected in "This is the Mailing Address"


So why when inserting a Mailing address using the Addressbook icon in Word
is there NO blank line in the addressblock, yet when creating a mail merge
label using the SAME mailing address in Outlook there IS a blank line? Seems
to me there's a major bug in the way mail merge handles the mailing address
in Outlook...

--
Asking a question?
Please tell us the version of the application you are asking about,
your OS, Service Pack level
and the FULL contents of any error message(s)

Insert Address uses AddressLayout. Mailmerge uses the layout you construct
in the merge.
Not a bug.
--
Russ Valentine
[MVP-Outlook]
"Gordon" wrote in message
...
"Russ Valentine [MVP-Outlook]" wrote in message
...
Yes. Outlook creates it from individual address elements according to the
option you have selected in "This is the Mailing Address"


So why when inserting a Mailing address using the Addressbook icon in Word
is there NO blank line in the addressblock, yet when creating a mail merge
label using the SAME mailing address in Outlook there IS a blank line?
Seems to me there's a major bug in the way mail merge handles the mailing
address in Outlook...

--
Asking a question?
Please tell us the version of the application you are asking about,
your OS, Service Pack level
and the FULL contents of any error message(s)