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 / June 2006

Tip: Looking for answers? Try searching our database.

using conditional merge, how do I not merge blank records...

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
sonia2080 - 22 Jun 2006 12:58 GMT
Hi all,

I am creating a word mail merge from an excel data source.  Using an IF
field I want to check whether column K (winner_700) contains data and if so,
to enter data from a different column (Entrants_Forename).  If it has no data
in column K, then I want the record to be ignored so it does not produce a
merged document.

So far I have constructed the following IF statement.  

{IF { MERGEFIELD winner_700 }<> "" "{ MERGEFIELD Entrants_Forename }" "" }

Is there any code I can enter to omit all records that contain no data in
the column so a merged letter is not produced?  I'm on Microsoft Office 2003.
Any help appreciated.  

Thanks,
Mindy
Doug Robbins - Word MVP - 22 Jun 2006 13:49 GMT
Use a Skip Record If field

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

> Hi all,
>
[quoted text clipped - 17 lines]
> Thanks,
> Mindy
 
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.