Formatting Issues

How to Preserve Bullets with Conditional Word Merge Fields

Khadija Khan Oct 21, 2026 868 views

Question details

The user needs to maintain bullet point formatting when a conditional IF merge field evaluates to false in a word processing document.

How to Preserve Bullets with Conditional Word Merge Fields

Product: Word Processor / Mail Merge
Device & OS: not provided
Scenario: Running a mail merge that includes a conditional IF field situated inside a bulleted list.
Observed behavior: The bullet formatting is removed or disappears entirely when the condition is false because the paragraph mark and bulleted paragraph are outside the field result.

Before you start

Ensure your mail merge data source is correctly linked to your document, and turn on hidden editing marks (¶) so you can accurately see paragraph breaks and spaces.

Solution 1Recommended

Apply Paragraph Styles and Enclose Content Inside the Field

By attaching bullet formatting to a paragraph style and placing the entire paragraph inside the IF field, you ensure the bullet is preserved regardless of the condition.

When you use direct bullet formatting, the conditional field might exclude the hidden characters that maintain the bullet point. Using a dedicated Paragraph Style and nesting the paragraph mark inside the field's true/false text solves this.

Create a Bulleted Paragraph Style

Instead of clicking the standard bullet button on the toolbar, open the Styles pane, create a new Paragraph Style, and apply bullet formatting directly to this style.

Toggle Document Field Codes

Press Alt+F9 on your keyboard to reveal the underlying mail merge field codes in your document.

Edit the Conditional IF Field

Locate your IF merge field. Move the entire bulleted paragraph into either the true-text or false-text quotation marks of the IF field, depending on your logic.

Include the Paragraph Mark

Ensure that the paragraph mark (¶) at the end of your bulleted text is also enclosed within the quotation marks of the IF field's result.

Apply Paragraph Styles and Enclose Content Inside the Field

Formatting Retained: This method forces the word processor to generate the entire bulleted paragraph structure only when the specific condition is met, preventing floating or disappearing bullets.

Advanced Mail Merge Solutions

Use WPS Writer for Seamless Mail Merge and Field Formatting

WPS Writer offers robust mail merge capabilities, allowing you to easily insert conditional IF fields, manage paragraph styles, and preserve document formatting without hassle.

1. Open WPS Writer: Launch WPS Office and open your main mail merge document.
2. Connect Your Data Source: Navigate to the References tab, click Mail Merge, and select Open Data Source to link your spreadsheet or database.
3. Insert Conditional Fields: Use the Mail Merge toolbar to insert an IF field. Right-click the field and select 'Toggle Field Codes' to manually edit the true and false text conditions.
4. Format and Merge: Apply your bulleted paragraph style inside the field codes. Finally, click 'Merge to New Document' to generate your customized files.

Advanced mail merge features with clear field code togglingFully compatible with Microsoft Word documents (.docx) and field codesIntuitive paragraph style management for bullets and numberingFree, lightweight, and user-friendly word processor

microsoft office alternative - wps office

Frequently Asked Questions

Why do bullet points disappear when a mail merge field is blank?

If bullet formatting is applied directly to a line containing a merge field, and that field evaluates to blank or false, the word processor may strip the formatting to prevent empty bullets. Enclosing the paragraph mark inside an IF field ensures the bullet is dynamically managed.

How do I view paragraph marks when editing mail merge fields?

You can view paragraph marks and other hidden formatting symbols by clicking the 'Show/Hide Editing Marks' icon (which looks like a ¶ symbol) located in the Home tab of your word processor.

Does WPS Office support IF conditional fields for mail merges?

Yes, WPS Writer fully supports standard Microsoft Word field codes, including advanced conditional IF, THEN, and ELSE statements necessary for complex mail merge operations.

Document & File Issues