Word Fields in Mail Merge document

[Stroppy]

Hi All,

I am setting up a mail merge using a form letter and excel or word data source. When inserting a Word Field, specifically, the "Skip Record If..." field, where does one actually insert it or doesn't it matter since it is a non printing field?

Also, lets say I wanted to put a merge record number on each form letter and corresponding addressed envelope, where would be a good place to put it?

Thanks,

M

 

[Doroth]

M –

I want to clarify what you are asking. I can see several possibilities about your intent, so I want to make sure I understand exactly what you want to do since you mention empty fields and skipping records.

-At first glance, it looks like you want to SKIP a complete record (including customer name, address, city, state, zip) rather than just an empty field. Is this true?

-Or, you don’t want blank lines to print.

-Or, you don’t want empty fields to print, but you want the populated items within the same line to print.

Once we know exactly what you need, it will be easier to answer.

In terms of where to put the number in the merged document, I would make sure that it wasn’t within or below the address – maybe in smaller print or in parentheses after the name, or a couple lines above the name/address.

 

[Stroppy]

Doroth, thanks for the reply. I am following a tutorial in a book on office 97, which suggests using word fields as a a way of filtering records. So, it says to insert a word field.."Skip record if..." "...state equals IL"

That's fine...it works. Thing is, they failed to mention where to insert it...in their tutorial, it was in the middle of a sentence (the last spot a FirstName data source field was inserted)

Whilst it works, I wonder where it should really be inserted.

Thanks again,

M