Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Ruud Ruud is offline
external usenet poster
 
Posts: 2
Default delte spacing in merged document

I'am merging a word template with an access database. Can somebody explain if
it is possible to automatically delete the line or blank space which occurs
when the the access field has no entry in the merged document

So as an example when the letter is adressed to a compnay

Mr. John Doe
XYZ Inc
P.O. Box 123
Etc

Or when there is no company and Mr. Doe is not a Mr.

John Doe

P.O Box 123
Etc.

Thanks for your assistence.
Kind Regards,
Ruud
  #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 delte spacing in merged document

You can do this by the use of If...then...Else field constructions in the
mail merge main documnet

e.g

{ IF { MERGEFIELD Title } = "" "{ MERGEFIELD FirstName }" "{ MERGEFIELD
Title } { MERGEFIELD FirstName }" }

and

{ IF { MERGEFIELD Company } = "" "{ MERGEFIELD Address1 }" "{ MERGEFIELD
Company }[Enter]
{ MERGEFIELD Address1 }" }

You must use Ctrl+F9 to insert each paird of field delimiters { } and in
place of the [Enter] in the second construction, you press the Enter key (or
Shift+Enter) at that point so that the balance of the field construction is
on a new line.

Use Alt+F9 to toggle off the display of the field codes.

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

"Ruud" wrote in message
...
I'am merging a word template with an access database. Can somebody explain
if
it is possible to automatically delete the line or blank space which
occurs
when the the access field has no entry in the merged document

So as an example when the letter is adressed to a compnay

Mr. John Doe
XYZ Inc
P.O. Box 123
Etc

Or when there is no company and Mr. Doe is not a Mr.

John Doe

P.O Box 123
Etc.

Thanks for your assistence.
Kind Regards,
Ruud



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Ruud Ruud is offline
external usenet poster
 
Posts: 2
Default delte spacing in merged document

Doug,

Thanks.
--
Kind Regards,
Ruud


"Doug Robbins - Word MVP" wrote:

You can do this by the use of If...then...Else field constructions in the
mail merge main documnet

e.g

{ IF { MERGEFIELD Title } = "" "{ MERGEFIELD FirstName }" "{ MERGEFIELD
Title } { MERGEFIELD FirstName }" }

and

{ IF { MERGEFIELD Company } = "" "{ MERGEFIELD Address1 }" "{ MERGEFIELD
Company }[Enter]
{ MERGEFIELD Address1 }" }

You must use Ctrl+F9 to insert each paird of field delimiters { } and in
place of the [Enter] in the second construction, you press the Enter key (or
Shift+Enter) at that point so that the balance of the field construction is
on a new line.

Use Alt+F9 to toggle off the display of the field codes.

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

"Ruud" wrote in message
...
I'am merging a word template with an access database. Can somebody explain
if
it is possible to automatically delete the line or blank space which
occurs
when the the access field has no entry in the merged document

So as an example when the letter is adressed to a compnay

Mr. John Doe
XYZ Inc
P.O. Box 123
Etc

Or when there is no company and Mr. Doe is not a Mr.

John Doe

P.O Box 123
Etc.

Thanks for your assistence.
Kind Regards,
Ruud




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
Unable to Find Merged Fields In Merged Document Joe[_2_] Mailmerge 3 April 2nd 07 08:39 AM
merged labels - how do you save the merged document for use later DanaFox Mailmerge 1 November 1st 06 08:05 PM
My document is double spacing but paragrah spacing is set at singl Double Spacing Microsoft Word Help 2 October 9th 06 07:35 PM
Mail merge spacing is inconsistent btw merged field and text? Lucy Mailmerge 4 September 24th 05 01:47 PM
how do I turn off the auto delte as I am typing? Robert Lawrence Microsoft Word Help 3 August 21st 05 04:26 PM


All times are GMT +1. The time now is 11:12 AM.

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

About Us

"It's about Microsoft Word"