[JohnH]

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