Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
JohnH JohnH is offline
external usenet poster
 
Posts: 32
Default Word 2007 Address Block and Suppress Blank Lines

I have several difficulties with Word 2007 and Merging
The Address Block when merged prints in 1.5 line spacing I can't make it
print single space.
I can't map the fields correctly because we use Prefix Fname LName Suffix
BusinessTitle Company Addr1 Addr2 City State Zip fields in my data. The
mapping choices don't accompdate this many fields (at least I can't see any
way to map and get the address block to display progerly)
I can't find anywhere/way to suppress blank fields (addr2) if I build my own
address block manually in the document. I did see one post about using
VisualBasic but I'm an enduser not a programmer.

Thanks
John

  #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 Word 2007 Address Block and Suppress Blank Lines

Don't use teh Address Block. Just insert the individual merge fields that
you want to use in the configuration that you want them.

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

"JohnH" wrote in message
...
I have several difficulties with Word 2007 and Merging
The Address Block when merged prints in 1.5 line spacing I can't make it
print single space.
I can't map the fields correctly because we use Prefix Fname LName Suffix
BusinessTitle Company Addr1 Addr2 City State Zip fields in my data. The
mapping choices don't accompdate this many fields (at least I can't see
any
way to map and get the address block to display progerly)
I can't find anywhere/way to suppress blank fields (addr2) if I build my
own
address block manually in the document. I did see one post about using
VisualBasic but I'm an enduser not a programmer.

Thanks
John



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
JohnH JohnH is offline
external usenet poster
 
Posts: 32
Default Word 2007 Address Block and Suppress Blank Lines

Thanks Doug, I've done that. I build an address from my data fields. The
addr2 field is often empty (I'm exporting from a sql data file into excel and
the field as best as I can see is blank/empty when there is no actual second
line of address). Perhaps I was not clear? When there is nothing in addr2 I
get a blank line between addr1 and the city st zip line. Same thing happens
when the businesstitle is blank, I get a blank line between fname lname and
company. How do I tell the merge filed to suppress if there is no data in it?
Thise seemed to happen automatically in 2000.

Thanks
John


"Doug Robbins - Word MVP" wrote:

Don't use teh Address Block. Just insert the individual merge fields that
you want to use in the configuration that you want them.

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

"JohnH" wrote in message
...
I have several difficulties with Word 2007 and Merging
The Address Block when merged prints in 1.5 line spacing I can't make it
print single space.
I can't map the fields correctly because we use Prefix Fname LName Suffix
BusinessTitle Company Addr1 Addr2 City State Zip fields in my data. The
mapping choices don't accompdate this many fields (at least I can't see
any
way to map and get the address block to display progerly)
I can't find anywhere/way to suppress blank fields (addr2) if I build my
own
address block manually in the document. I did see one post about using
VisualBasic but I'm an enduser not a programmer.

Thanks
John




  #4   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 Word 2007 Address Block and Suppress Blank Lines

You will need to use and If...then...Else field construction. There are
numerous posts in this newsgroup that contain examples of such
constructions.

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

"JohnH" wrote in message
...
Thanks Doug, I've done that. I build an address from my data fields. The
addr2 field is often empty (I'm exporting from a sql data file into excel
and
the field as best as I can see is blank/empty when there is no actual
second
line of address). Perhaps I was not clear? When there is nothing in addr2
I
get a blank line between addr1 and the city st zip line. Same thing
happens
when the businesstitle is blank, I get a blank line between fname lname
and
company. How do I tell the merge filed to suppress if there is no data in
it?
Thise seemed to happen automatically in 2000.

Thanks
John


"Doug Robbins - Word MVP" wrote:

Don't use teh Address Block. Just insert the individual merge fields
that
you want to use in the configuration that you want them.

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

"JohnH" wrote in message
...
I have several difficulties with Word 2007 and Merging
The Address Block when merged prints in 1.5 line spacing I can't make
it
print single space.
I can't map the fields correctly because we use Prefix Fname LName
Suffix
BusinessTitle Company Addr1 Addr2 City State Zip fields in my data. The
mapping choices don't accompdate this many fields (at least I can't see
any
way to map and get the address block to display progerly)
I can't find anywhere/way to suppress blank fields (addr2) if I build
my
own
address block manually in the document. I did see one post about using
VisualBasic but I'm an enduser not a programmer.

Thanks
John






  #5   Report Post  
Posted to microsoft.public.word.mailmerge.fields
JohnH JohnH is offline
external usenet poster
 
Posts: 32
Default Word 2007 Address Block and Suppress Blank Lines

Thanks again Doug, I guess I just don't see the forest for the trees? I 've
looked through post of if else but don't see any pertaining to skipping a
blank field. All the examples I see skip / move on to the next record. I've
tried several search variations but come up blank (pun intented )

If anyone knows of such a post example I'd appreciate a heads up and/or
where on the MS help docs this might be addressed?

Thanks
John


"Doug Robbins - Word MVP" wrote:

You will need to use and If...then...Else field construction. There are
numerous posts in this newsgroup that contain examples of such
constructions.

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

"JohnH" wrote in message
...
Thanks Doug, I've done that. I build an address from my data fields. The
addr2 field is often empty (I'm exporting from a sql data file into excel
and
the field as best as I can see is blank/empty when there is no actual
second
line of address). Perhaps I was not clear? When there is nothing in addr2
I
get a blank line between addr1 and the city st zip line. Same thing
happens
when the businesstitle is blank, I get a blank line between fname lname
and
company. How do I tell the merge filed to suppress if there is no data in
it?
Thise seemed to happen automatically in 2000.

Thanks
John


"Doug Robbins - Word MVP" wrote:

Don't use teh Address Block. Just insert the individual merge fields
that
you want to use in the configuration that you want them.

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

"JohnH" wrote in message
...
I have several difficulties with Word 2007 and Merging
The Address Block when merged prints in 1.5 line spacing I can't make
it
print single space.
I can't map the fields correctly because we use Prefix Fname LName
Suffix
BusinessTitle Company Addr1 Addr2 City State Zip fields in my data. The
mapping choices don't accompdate this many fields (at least I can't see
any
way to map and get the address block to display progerly)
I can't find anywhere/way to suppress blank fields (addr2) if I build
my
own
address block manually in the document. I did see one post about using
VisualBasic but I'm an enduser not a programmer.

Thanks
John









  #6   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 Word 2007 Address Block and Suppress Blank Lines

See the post "Problems with IF statement" started by Joe Di Giulio on
11/8/2007 that was hijacked by Briza on 11/9/2007 to which both I and Graham
Mayor responded.

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

"JohnH" wrote in message
...
Thanks again Doug, I guess I just don't see the forest for the trees? I
've
looked through post of if else but don't see any pertaining to skipping a
blank field. All the examples I see skip / move on to the next record.
I've
tried several search variations but come up blank (pun intented )

If anyone knows of such a post example I'd appreciate a heads up and/or
where on the MS help docs this might be addressed?

Thanks
John


"Doug Robbins - Word MVP" wrote:

You will need to use and If...then...Else field construction. There are
numerous posts in this newsgroup that contain examples of such
constructions.

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

"JohnH" wrote in message
...
Thanks Doug, I've done that. I build an address from my data fields.
The
addr2 field is often empty (I'm exporting from a sql data file into
excel
and
the field as best as I can see is blank/empty when there is no actual
second
line of address). Perhaps I was not clear? When there is nothing in
addr2
I
get a blank line between addr1 and the city st zip line. Same thing
happens
when the businesstitle is blank, I get a blank line between fname lname
and
company. How do I tell the merge filed to suppress if there is no data
in
it?
Thise seemed to happen automatically in 2000.

Thanks
John


"Doug Robbins - Word MVP" wrote:

Don't use teh Address Block. Just insert the individual merge fields
that
you want to use in the configuration that you want them.

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

"JohnH" wrote in message
...
I have several difficulties with Word 2007 and Merging
The Address Block when merged prints in 1.5 line spacing I can't
make
it
print single space.
I can't map the fields correctly because we use Prefix Fname LName
Suffix
BusinessTitle Company Addr1 Addr2 City State Zip fields in my data.
The
mapping choices don't accompdate this many fields (at least I can't
see
any
way to map and get the address block to display progerly)
I can't find anywhere/way to suppress blank fields (addr2) if I
build
my
own
address block manually in the document. I did see one post about
using
VisualBasic but I'm an enduser not a programmer.

Thanks
John









  #7   Report Post  
Posted to microsoft.public.word.mailmerge.fields
LTS LTS is offline
external usenet poster
 
Posts: 4
Default Word 2007 Address Block and Suppress Blank Lines

John,
You can change the line spacing by selecting the fields and using the Word
2007 Home/Paragraph option. The suppress blank lines should be an option of
the AddressBlock field but for some reason Word 2007 has taken a step
backward. Putting in the individual fields is not the same as using the
AddressBlock as it includes foreign country address reformatting and local
country supression. Also, suggesting using IF is not an option for an end
user and I have had problems with the MailMergeHelper macro.

My conclusion is that an end user cannot use Word 2007 to print labels
correctly. I am happy to be corrected as I have been trying to do the same
thing myself. In the end I printed the labels with blank lines.

Laurence

"JohnH" wrote:

I have several difficulties with Word 2007 and Merging
The Address Block when merged prints in 1.5 line spacing I can't make it
print single space.
I can't map the fields correctly because we use Prefix Fname LName Suffix
BusinessTitle Company Addr1 Addr2 City State Zip fields in my data. The
mapping choices don't accompdate this many fields (at least I can't see any
way to map and get the address block to display progerly)
I can't find anywhere/way to suppress blank fields (addr2) if I build my own
address block manually in the document. I did see one post about using
VisualBasic but I'm an enduser not a programmer.

Thanks
John

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
Stop blank lines appearing when using Address Block with a databa TonyB Mailmerge 1 September 11th 07 08:37 PM
How do you suppress blank lines when merging address labels? Jan Admin Suprv Mailmerge 2 August 29th 07 07:57 AM
surpressing blank lines in address block cbeck29483 Mailmerge 1 May 20th 05 02:10 PM
How do I suppress blank address lines in Word2003 mail merge? JonUK5691 Mailmerge 1 March 22nd 05 09:31 PM
In Word 2002, how do I suppress blank lines in an address? geller Mailmerge 1 February 2nd 05 05:50 AM


All times are GMT +1. The time now is 10:07 PM.

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

About Us

"It's about Microsoft Word"