80 likes | 293 Views
Looking at field codes as part of. Mail Merge. Using Fill-in & Skip-if.
E N D
Looking at field codes as part of Mail Merge
Using Fill-in & Skip-if Q) After creating your letter, at the time of production, the price of the engine overhaul will be inserted manually at run time & the name of the contact at the boatyard will be given – it will usually be Christopher Moon, but may be one of the other mechanics. Letters will only be sent to all customers who bought power boats or jet skis, except Mr. ShahadSharreif.
Fill-in 1 Select the text enter price here by highlighting it You will need to replace this text with a FILL IN command From the mail merge toolbar, select ‘Rules’ and from the drop down menu, select ‘Fill-in…’ In the ‘Prompt’ section, type the text ‘Please enter price here’ 4 3
Skip-if Click anywhere on the document From the mail merge toolbar, select ‘Rules’ & from the drop down menu, select ‘Skip Record If’ Since the question says we need to skip Mr. Shahad, we need to select Forename from the drop down menu in ‘Field name’, Equal to in the comparison and type in Shahad in the ‘Compare to’ section 3 2