Mail merge problem (Office 2007)

  • Thread starter Thread starter Portagepa
  • Start date Start date
P

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?
 
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
 
Thanks Doug. I'll give it a try.

Doug Robbins - Word MVP said:
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
Click to expand...
 
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."
 
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
 
Back
Top