Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / July 2007

Tip: Looking for answers? Try searching our database.

delte spacing in merged document

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Ruud - 14 Jul 2007 06:26 GMT
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
Doug Robbins - Word MVP - 14 Jul 2007 09:02 GMT
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.

Signature

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

> I'am merging a word template with an access database. Can somebody explain
> if
[quoted text clipped - 19 lines]
> Kind Regards,
> Ruud
Ruud - 16 Jul 2007 20:42 GMT
Doug,

Thanks.
Signature

Kind Regards,
Ruud

> You can do this by the use of If...then...Else field constructions in the
> mail merge main documnet
[quoted text clipped - 40 lines]
> > Kind Regards,
> > Ruud

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.