Losing Formatting in Merge
Hi All,
When trying to merge letters locally, I noticed I am losing formatting and extra spacing is being added. Support claims that this is now out of scope. Anyone else experiencing this as they try this new workflow?
Comments
-
Update: simple merges work fine, conditional get messed up
2 -
I have found that Word (365 license) is not suppressing lines when the field is blank. I have been using a switch (\\f) that has worked for me for about a year. It specifies that the text to be inserted following the merge field if the field is not blank.
A sample merge field with this looks like this:
(for anyone new to this: copying and pasting this will not work as you need to use ctrl F9 to insert the brackets for a merge field){ MERGEFIELD CnAdrPrf_Addrline3 \\f"¶
"}Hope this helps and I'd love to know if there are easier solutions (always) – however, @Chris Snow it sounds like your issue may be different.
0 -
Hi @Chris Snow - I recommend you check out KB Article #46272, it has some helpful tips & tricks to help with keeping formatting through a conditional merge. I recommend you start by switching out “MERGEFORMAT” with “CHARFORMAT” within your conditional statements and work from there.
There was a recent posted on Facebook RE User Group that discussed changing the default style for the main document - before entering any conditional statements. I have linked the original post below - the suggested solution is listed in the third comment:1 -
I am still having problems with Word adding the /MERGEFORMAT field after changing it to /*CHARFORMAT. On top of that, CHARFORMAT is removing all of the formatting, so none of my fields are retaining any special formatting at all. All of my emphasis and italics formatting is removed when I use CHARFORMAT, but MERGEFORMAT gives me inconsistent formatting, bolding things that are not supposed to be bolded at all.
1 -
I'm also having this issue and looking for a solution. Bold and italics aren't retained with CHARFORMAT and with MERGEFORMAT bold and italics are randomly applied.
0 -
I read this on FB and they said it worked. Im going to try it.
make sure the template and the letters all have the same "style," and in the merge if-then-else, do NOT select keep formatting.
0 -
I'm now finding that conditional merges are not only getting messed up, they aren't even getting to the point of producing letters--I receive a random SQL error and nothing generates at the end of it, and no source data is retained. The attempted mail merge now fails for me about ⅓ of the time, so if I've marked the gifts as Acknowledged during the merge process, I have to go back and Unacknowledge the donation records, reboot Raiser's Edge and give the merge another attempt.
0 -
I tried @Patti Posey ‘s suggestion of unchecking ’preserve formatting during updates' when editing the field inside the {brackets}. So far, it seems to have worked. My bolds are bold, my italics are italic, and my soul is at ease…….for now. ?
1 -
After successfully making it through this process and building a Multi-Conditional Merge, here is what I have found that works to keep formatting.
- Before starting anything, edit the “Normal” Theme for your word documents, and make sure to select “New documents based on this template”
- If MERGEFORMAT or CHARFORMAT are included in your conditional statements, remove them. I found these prevented the formatting in my templates from appearing in the final merge doc (formatting = bold and italics).
0 -
Austen Brown:
After successfully making it through this process and building a Multi-Conditional Merge, here is what I have found that works to keep formatting.
- Before starting anything, edit the “Normal” Theme for your word documents, and make sure to select “New documents based on this template”
- If MERGEFORMAT or CHARFORMAT are included in your conditional statements, remove them. I found these prevented the formatting in my templates from appearing in the final merge doc (formatting = bold and italics).
I second this recommendation! I was having formatting issues as well until I changed the “normal” format setting to the correct formats.
0 -
Chris Snow:
Hi All,
When trying to merge letters locally, I noticed I am losing formatting and extra spacing is being added. Support claims that this is now out of scope. Anyone else experiencing this as they try this new workflow?
I found because the word docs from RE are an older version of word it was messing with the formatting when I saved it and it updated to a newer version. To stop it from doing that, when saving I selected “maintain compatibility with previous versions of word” and I haven't had an issue since, but I've also heard this hasn't worked for everyone
0 -
I am so thankful for all the responses to this delimma! After months of cleaning up merged acknowledgement letters one-by-one, I finally got fed up enough to really troubleshoot and resolve this. For me, unchecking the “preserve formatting during updates” box worked. I found that doing this also automatically removed the /MERGEFORMAT code from each condition. And I didn't need to redo the master conditional merge document. Just clicked on each letter setup in the document, right-clicked to ‘edit field’, and unchecked the box. Now my letters have merged with all of my templates' formatting intact. I am thrilled!
1
Categories
- All Categories
- Shannon parent
- shannon 2
- shannon 1
- 21 Advocacy DC Users Group
- 14 BBCRM PAG Discussions
- 89 High Education Program Advisory Group (HE PAG)
- 28 Luminate CRM DC Users Group
- 8 DC Luminate CRM Users Group
- Luminate PAG
- 5.9K Blackbaud Altru®
- 58 Blackbaud Award Management™ and Blackbaud Stewardship Management™
- 409 bbcon®
- 2K Blackbaud CRM™ and Blackbaud Internet Solutions™
- donorCentrics®
- 1.1K Blackbaud eTapestry®
- 2.8K Blackbaud Financial Edge NXT®
- 1.1K Blackbaud Grantmaking™
- 527 Education Management Solutions for Higher Education
- 21 Blackbaud Impact Edge™
- 1 JustGiving® from Blackbaud®
- 4.6K Education Management Solutions for K-12 Schools
- Blackbaud Luminate Online & Blackbaud TeamRaiser
- 16.4K Blackbaud Raiser's Edge NXT®
- 4.1K SKY Developer
- 547 ResearchPoint™
- 151 Blackbaud Tuition Management™
- 1 YourCause® from Blackbaud®
- 61 everydayhero
- 3 Campaign Ideas
- 58 General Discussion
- 115 Blackbaud ID
- 87 K-12 Blackbaud ID
- 6 Admin Console
- 949 Organizational Best Practices
- 353 The Tap (Just for Fun)
- 235 Blackbaud Community Feedback Forum
- 124 Ninja Secret Society
- 32 Blackbaud Raiser's Edge NXT® Receipting EAP
- 55 Admissions Event Management EAP
- 18 MobilePay Terminal + BBID Canada EAP
- 36 EAP for New Email Campaigns Experience in Blackbaud Luminate Online®
- 109 EAP for 360 Student Profile in Blackbaud Student Information System
- 41 EAP for Assessment Builder in Blackbaud Learning Management System™
- 9 Technical Preview for SKY API for Blackbaud CRM™ and Blackbaud Altru®
- 55 Community Advisory Group
- 46 Blackbaud Community Ideas
- 26 Blackbaud Community Challenges
- 7 Security Testing Forum
- 1.1K ARCHIVED FORUMS | Inactive and/or Completed EAPs
- 3 Blackbaud Staff Discussions
- 7.7K ARCHIVED FORUM CATEGORY [ID 304]
- 1 Blackbaud Partners Discussions
- 1 Blackbaud Giving Search™
- 35 EAP Student Assignment Details and Assignment Center
- 39 EAP Core - Roles and Tasks
- 59 Blackbaud Community All-Stars Discussions
- 20 Blackbaud Raiser's Edge NXT® Online Giving EAP
- Diocesan Blackbaud Raiser’s Edge NXT® User’s Group
- 2 Blackbaud Consultant’s Community
- 43 End of Term Grade Entry EAP
- 92 EAP for Query in Blackbaud Raiser's Edge NXT®
- 38 Standard Reports for Blackbaud Raiser's Edge NXT® EAP
- 12 Payments Assistant for Blackbaud Financial Edge NXT® EAP
- 6 Ask an All Star (Austen Brown)
- 8 Ask an All-Star Alex Wong (Blackbaud Raiser's Edge NXT®)
- 1 Ask an All-Star Alex Wong (Blackbaud Financial Edge NXT®)
- 6 Ask an All-Star (Christine Robertson)
- 21 Ask an Expert (Anthony Gallo)
- Blackbaud Francophone Group
- 22 Ask an Expert (David Springer)
- 4 Raiser's Edge NXT PowerUp Challenge #1 (Query)
- 6 Ask an All-Star Sunshine Reinken Watson and Carlene Johnson
- 4 Raiser's Edge NXT PowerUp Challenge: Events
- 14 Ask an All-Star (Elizabeth Johnson)
- 7 Ask an Expert (Stephen Churchill)
- 2025 ARCHIVED FORUM POSTS
- 322 ARCHIVED | Financial Edge® Tips and Tricks
- 164 ARCHIVED | Raiser's Edge® Blog
- 300 ARCHIVED | Raiser's Edge® Blog
- 441 ARCHIVED | Blackbaud Altru® Tips and Tricks
- 66 ARCHIVED | Blackbaud NetCommunity™ Blog
- 211 ARCHIVED | Blackbaud Target Analytics® Tips and Tricks
- 47 Blackbaud CRM Higher Ed Product Advisory Group (HE PAG)
- Luminate CRM DC Users Group
- 225 ARCHIVED | Blackbaud eTapestry® Tips and Tricks
- 1 Blackbaud eTapestry® Know How Blog
- 19 Blackbaud CRM Product Advisory Group (BBCRM PAG)
- 1 Blackbaud K-12 Education Solutions™ Blog
- 280 ARCHIVED | Mixed Community Announcements
- 3 ARCHIVED | Blackbaud Corporations™ & Blackbaud Foundations™ Hosting Status
- 1 npEngage
- 24 ARCHIVED | K-12 Announcements
- 15 ARCHIVED | FIMS Host*Net Hosting Status
- 23 ARCHIVED | Blackbaud Outcomes & Online Applications (IGAM) Hosting Status
- 22 ARCHIVED | Blackbaud DonorCentral Hosting Status
- 14 ARCHIVED | Blackbaud Grantmaking™ UK Hosting Status
- 117 ARCHIVED | Blackbaud CRM™ and Blackbaud Internet Solutions™ Announcements
- 50 Blackbaud NetCommunity™ Blog
- 169 ARCHIVED | Blackbaud Grantmaking™ Tips and Tricks
- Advocacy DC Users Group
- 718 Community News
- Blackbaud Altru® Hosting Status
- 104 ARCHIVED | Member Spotlight
- 145 ARCHIVED | Hosting Blog
- 149 JustGiving® from Blackbaud® Blog
- 97 ARCHIVED | bbcon® Blogs
- 19 ARCHIVED | Blackbaud Luminate CRM™ Announcements
- 161 Luminate Advocacy News
- 187 Organizational Best Practices Blog
- 67 everydayhero Blog
- 52 Blackbaud SKY® Reporting Announcements
- 17 ARCHIVED | Blackbaud SKY® Reporting for K-12 Announcements
- 3 Luminate Online Product Advisory Group (LO PAG)
- 81 ARCHIVED | JustGiving® from Blackbaud® Tips and Tricks
- 1 ARCHIVED | K-12 Conference Blog
- Blackbaud Church Management™ Announcements
- ARCHIVED | Blackbaud Award Management™ and Blackbaud Stewardship Management™ Announcements
- 1 Blackbaud Peer-to-Peer Fundraising™, Powered by JustGiving® Blogs
- 39 Tips, Tricks, and Timesavers!
- 56 Blackbaud Church Management™ Resources
- 154 Blackbaud Church Management™ Announcements
- 1 ARCHIVED | Blackbaud Church Management™ Tips and Tricks
- 11 ARCHIVED | Blackbaud Higher Education Solutions™ Announcements
- 7 ARCHIVED | Blackbaud Guided Fundraising™ Blog
- 2 Blackbaud Fundraiser Performance Management™ Blog
- 9 Foundations Events and Content
- 14 ARCHIVED | Blog Posts
- 2 ARCHIVED | Blackbaud FIMS™ Announcement and Tips
- 59 Blackbaud Partner Announcements
- 10 ARCHIVED | Blackbaud Impact Edge™ EAP Blogs
- 1 Community Help Blogs
- Diocesan Blackbaud Raiser’s Edge NXT® Users' Group
- Blackbaud Consultant’s Community
- Blackbaud Francophone Group
- 1 BLOG ARCHIVE CATEGORY
- Blackbaud Community™ Discussions
- 8.3K Blackbaud Luminate Online® & Blackbaud TeamRaiser® Discussions
- 5.7K Jobs Board