A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Outlook » Contacts
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Blank Line in Mail Merge Address Labels



 
 
Thread Tools Display Modes
  #11  
Old December 9th, 2008, 07:34 AM posted to microsoft.public.outlook.contacts
Gordon[_10_]
external usenet poster
 
Posts: 2,460
Default Blank Line in Mail Merge Address Labels

"Russ Valentine [MVP-Outlook]" wrote in message
...
Insert Address uses AddressLayout. Mailmerge uses the layout you construct
in the merge.
Not a bug.


OK so not a bug, but some un-joined up thinking then. Yes the merge should
be customisable, but why, when specifically merging mailing addresses, does
it not specifically use AddressLayout? Seems daft to me.

--
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)

  #12  
Old December 9th, 2008, 11:21 AM posted to microsoft.public.outlook.contacts
Russ Valentine [MVP-Outlook]
external usenet poster
 
Posts: 9,440
Default Blank Line in Mail Merge Address Labels

I explained that. Mailing Address is a field derived by Outlook. By design,
Mailing Address does not suppress blank lines in the field itself. Blank
lines can only be suppressed in Word by using curly braces on a field when
you construct the merge.
--
Russ Valentine
[MVP-Outlook]
"Gordon" wrote in message
...
"Russ Valentine [MVP-Outlook]" wrote in message
...
Insert Address uses AddressLayout. Mailmerge uses the layout you
construct in the merge.
Not a bug.


OK so not a bug, but some un-joined up thinking then. Yes the merge should
be customisable, but why, when specifically merging mailing addresses,
does it not specifically use AddressLayout? Seems daft to me.

--
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)


  #13  
Old December 10th, 2008, 03:59 PM posted to microsoft.public.outlook.contacts
BobRob
external usenet poster
 
Posts: 46
Default Blank Line in Mail Merge Address Labels

Russ and Gordon,

After a lot of thinking I have decided to leave my mailing labels as is and
correct them manually on the couple of occasions a year I do a label run. If
I was a "techie" or doing a lot of label runs I would take a different course
of action. Thank you especially RUSS for your help and advice.

"Russ Valentine [MVP-Outlook]" wrote:

I explained that. Mailing Address is a field derived by Outlook. By design,
Mailing Address does not suppress blank lines in the field itself. Blank
lines can only be suppressed in Word by using curly braces on a field when
you construct the merge.
--
Russ Valentine
[MVP-Outlook]
"Gordon" wrote in message
...
"Russ Valentine [MVP-Outlook]" wrote in message
...
Insert Address uses AddressLayout. Mailmerge uses the layout you
construct in the merge.
Not a bug.


OK so not a bug, but some un-joined up thinking then. Yes the merge should
be customisable, but why, when specifically merging mailing addresses,
does it not specifically use AddressLayout? Seems daft to me.

--
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)



  #14  
Old December 10th, 2008, 09:11 PM posted to microsoft.public.outlook.contacts
Russ Valentine [MVP-Outlook]
external usenet poster
 
Posts: 9,440
Default Blank Line in Mail Merge Address Labels

That works. Mail merges certainly aren't very user friendly, are they?
--
Russ Valentine
[MVP-Outlook]
"BobRob" wrote in message
...
Russ and Gordon,

After a lot of thinking I have decided to leave my mailing labels as is
and
correct them manually on the couple of occasions a year I do a label run.
If
I was a "techie" or doing a lot of label runs I would take a different
course
of action. Thank you especially RUSS for your help and advice.

"Russ Valentine [MVP-Outlook]" wrote:

I explained that. Mailing Address is a field derived by Outlook. By
design,
Mailing Address does not suppress blank lines in the field itself. Blank
lines can only be suppressed in Word by using curly braces on a field
when
you construct the merge.
--
Russ Valentine
[MVP-Outlook]
"Gordon" wrote in message
...
"Russ Valentine [MVP-Outlook]" wrote in message
...
Insert Address uses AddressLayout. Mailmerge uses the layout you
construct in the merge.
Not a bug.

OK so not a bug, but some un-joined up thinking then. Yes the merge
should
be customisable, but why, when specifically merging mailing addresses,
does it not specifically use AddressLayout? Seems daft to me.

--
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)




 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:17 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.