#1
|
|||
|
|||
Suppressing Blank Conditional Sections in Mail Merge
Hello -
I am working on an Excel to Word mail merge that creates employee salary increase letters. I have a few conditional sections in the mail merge document that are working correctly, but I'm having a formatting challenge. If the section is blank/not applicable for an employee, I would like it to skip over that section entirely in the document, not showing any blank spaces. Instead what I'm seeing are blank line that I'm unable to suppress. I've done some reading and tried using \b and \f switches but haven't had any luck as yet. Below is a sample of the document. The bolded section is an example of the section that I'd like skipped over entirely, without leaving blank spaces, if someone is not eligible for a salary increase. --- STATIC TEXT HERE { if { MERGEFIELD Salary_Increase_Pct }="0.00%" "Your salary will remain the same at this time." "We are pleased to increase your annual salary by { MERGEFIELD Salary_Increase_Pct } to { MERGEFIELD Proposed_Salary }. This change will be effective from { MERGEFIELD Salary_Inc_Eff_Date }. You will receive the adjustment on your { MERGEFIELD Salary_Inc_Payroll_Period } payroll."} STATIC TEXT HERE --- Any help would be greatly appreciated - thank you! |
#2
|
||||
|
||||
Presumably, with Word's formatting display switched on, what you have is:
Quote:
Quote:
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
||||
|
||||
Cross-posted at: Suppressing Blank Conditional Sections in Mail Merge
For cross-posting etiquette, please read: Excelguru Help Site - A message to forum cross posters
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#4
|
|||
|
|||
This did the trick! Thank you so much, Paul; very much appreciated.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Need help suppressing information in a table in a mail merge | Laura123 | Mail Merge | 1 | 12-04-2017 01:34 PM |
Conditional Text without Mail Merge | wvdh | Word | 3 | 10-05-2017 02:38 AM |
I know nothing about mail merge, but need help with conditional statements | briyosa | Word | 1 | 03-27-2017 10:17 PM |
Mail merge in sections with address list | patrickpetersen | Mail Merge | 1 | 02-18-2015 10:57 PM |
Conditional merge fields in mail merge | Aude | Mail Merge | 1 | 01-06-2012 07:38 PM |