7. Other Word Fields

ifIF .. THEN .. ELSE

This has a decision structure and is used to make choices e.g. IF gender is 'Male' THEN enter 'Mr' ELSE enter 'Ms'

 

NEXT RECORD

This merges the next data record into the current document.

Each record is usually contained on a different page

 

SKIP RECORD IF

Two conditions are compared.

If true (condition is met) then record is skipped, if false (condition not met) then record is used.

E.g. if balance owing = £0.00 then don't send a threatening letter. If balance >£0.00 then send a threatening letter.

 

Exam hint:

Exam questions often ask you to explain the benefits of using word fields. Here are some of the answers that you could use:

Can be used to take data from other sources

Can filter out unwanted data

Can use them to run a macro

Can insert standard information such as date/time

 

challenge see if you can find out one extra fact on this topic that we haven't already told you

Click on this link: Mail Merge Word Fields