#1
|
|||
|
|||
Mail Merge - Conditional Statements
Hi,
Is it possible in a mailmerge to set up a conditional statement where a monetary figure is quoted but would be different for each person. for example if Joe Bloggs received a car allowance, it would show in Column C of the excel data sheet as Yes or No and Column D would have a monetary value of GBPX to denote the car allowance amount. The wording might be for example " You shall receive a car allowance of GBPX (insert figure from Column D) per month" Michael Grant for example might also receive a car allowance but with a different amount. Edward House would not receive a car allowance and therefore the sentence wouldn't be required at all. Can anyone advise? thanks in advance |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
IF statements in mail merge with results displayed based on date of letter | ajh19742000 | Mail Merge | 1 | 11-13-2019 01:54 PM |
IF Statements for a several ranges of values using Mail Merge | Jennifert | Mail Merge | 2 | 05-01-2019 09:40 PM |
I know nothing about mail merge, but need help with conditional statements | briyosa | Word | 1 | 03-27-2017 10:17 PM |
Using multiple IF statements on a mail merge | ajh19742000 | Mail Merge | 1 | 11-01-2016 06:11 PM |
showing results of If statements in a mail merge | m&co | Mail Merge | 3 | 01-06-2012 07:27 PM |