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