Doug, Thanks a million. This is exactly what I needed. Joes D's post flows
exactly as I would have struggled with the process.
Really great help -Thanks again
John
"Doug Robbins - Word MVP" wrote:
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