Mail merge problem (Office 2007)

[Portagepa]

In the Address Block, Word is adding a blank line between the street address
and the city/state/zip whenever there is a 2 line street address in an
Outlook Contact. Why and how to fix?

 

[Doug Robbins - Word MVP]

Instead of using the Address Block, just insert the actual merge fields in
the configuration that you want them. To eliminate a blank line where the
Address2 field contains no data, you will need to use an If...then...Else
field construction

{ IF { MERGEFIELD Address2 } = "" "{ MERGEFIELD City } { MERGEFIELD State }
{ MERGEFIELD Zip }" "{MERGEFIELD Address2 }¶
{ MERGEFIELD City } { MERGEFIELD State } { MERGEFIELD Zip }" }

You must use Ctrl+F9 to insert each pair of field delimiters { } and use
Alt+F9 to toggle off their display. Where the pilcrow (¶) appears in the
above construction, press the Enter Key or Shift+Enter.

--
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, originally posted via msnews.microsoft.com

 

[Portagepa]

Thanks Doug. I'll give it a try.

Instead of using the Address Block, just insert the actual merge fields in
the configuration that you want them. To eliminate a blank line where the
Address2 field contains no data, you will need to use an If...then...Else
field construction

{ IF { MERGEFIELD Address2 } = "" "{ MERGEFIELD City } { MERGEFIELD State }
{ MERGEFIELD Zip }" "{MERGEFIELD Address2 }¶
{ MERGEFIELD City } { MERGEFIELD State } { MERGEFIELD Zip }" }

You must use Ctrl+F9 to insert each pair of field delimiters { } and use
Alt+F9 to toggle off their display. Where the pilcrow (¶) appears in the
above construction, press the Enter Key or Shift+Enter.

--
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, originally posted via msnews.microsoft.com

 

[Portagepa]

I tried manually putting in the code Doug suggested but got this an "Invalid
Merge Field. The merge field "Address2" is used in the main document, but
does not exist in the data source."

 

[Doug Robbins - Word MVP]

The field should probably be Address 2

What do you see in the Insert MergeFields dropdown?

--
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, originally posted via msnews.microsoft.com