Cheers for that...BUT..... having just tried it with Skip record If and next Record If it's still not doing it... I've put the fields at the beginning of the document and tried it also with them just before the first merge field, I must be doing something wrong here or am a complete dork.... Words never beaten me before!!!

Any other ideas???? Its frying my brain!

Many Thank

And
   
    ----- Doug Robbins - Word MVP wrote: ----
   
    The SkipRecordIf field must precede any mergefields in the main document
   
    --
    Please post any further questions or followup to the newsgroups for th
    benefit of others who may be interested.  Unsolicited questions forwarde
    directly to me will only be answered on a paid consulting basis
   
    Hope this help
    Doug Robbins - Word MV
    "Andrew Elliott" <anonymous@discussions.microsoft.com> wrote in messag
    news:AB851785-CC35-4142-864B-E9ED79B388A6@microsoft.com..
    > Hi Guys
    >> Bit of a weird one that i cant get my head around. I have an exce
    spreadsheet that I'm using for data capture. I've a word document that I'v
    got a letter in and have inserted merge fields that it picks up from th
    excel file. It all works just fine so so no worries there. However I won'
    be doing all the letters at once, and i have a column in my excel sheet tha
    is called Letter Sent, if i have sent a letter I put y in it (which make
    sense!!) My problem is I want word to skip any rows in the excel file that
    in the letter sent column so I don;t do the same letters twice or 3 time
    even!! I thik that makes sense..... I thought I could pop in a word field.
    'Skip Record If' and set the it look for y in the Letter Sent column...
    fairly basic really... however it doesnt... it just plows on through th
    whole lot .... anyone know how to do this without resorting to changes i
    excel??
    >> Cheers guy
    >> And