Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
using conditional merge, how do I not merge blank records...
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 |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
using conditional merge, how do I not merge blank records...
Use a Skip Record If field
-- 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 "sonia2080" wrote in message ... 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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I eliminate extra blank pages from a mail merge? | Mailmerge | |||
Why is my merge skipping records? | Mailmerge | |||
How to Mail merge records into a new/separate document | Mailmerge | |||
Does anyone know how to include blank records from an Excel datab. | Microsoft Word Help | |||
Conditional mail merge | Mailmerge |