Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-26-2012, 06:24 AM
Welshie82 Welshie82 is offline Merge Field Formatting Windows 7 32bit Merge Field Formatting Office 2007
Advanced Beginner
Merge Field Formatting
 
Join Date: Oct 2011
Location: Birmingham
Posts: 33
Welshie82 is on a distinguished road
Angry Merge Field Formatting

I have a document, in Word 2007, which uses merge fields to pull information from a Case Management Database. The problematic mergefield pulls in a single line of text which has an address in it.



The field is «Case_BC_I1_13»
Which, for example, fills in a spot in the letter as: 1 Example Street, Example Town, Example County, Post Code.


In the form document the field is bolded, as it is part of a subject line. But the problem is that when the document is merged the line of text is formatted as:
1 Example Street, Example Town, Example County, Post Code.

The latter part doesn't bold and I cannot figure out how to make the whole sentence bold. I'm sure it's a switch or something that I'm not aware of. Can anyone suggest anything?


Thanks!!
Reply With Quote
  #2  
Old 09-26-2012, 03:37 PM
macropod's Avatar
macropod macropod is online now Merge Field Formatting Windows 7 64bit Merge Field Formatting Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi Welshie,

To control the mailmerge string formatting, add a 'Charformat' picture switch to the mergefield as follows:
• select the mergefield;
• press Shift-F9 to expose the field coding. It should look something like {MERGEFIELD Case_BC_I1_13}, where 'Case_BC_I1_13' is your data field's name;
• delete everything between 'Case_BC_I1_13' and the closing field brace;
• add ' \* Charformat' after 'Case_BC_I1_13', so that you end up with {MERGEFIELD Case_BC_I1_13 \* Charformat};
• format at least the 'M' in 'MERGEFIELD' with the font attributes you want;
• position the cursor anywhere in the field and press F9 to update it.
• run your mailmerge.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 09-27-2012, 02:30 AM
Welshie82 Welshie82 is offline Merge Field Formatting Windows 7 32bit Merge Field Formatting Office 2007
Advanced Beginner
Merge Field Formatting
 
Join Date: Oct 2011
Location: Birmingham
Posts: 33
Welshie82 is on a distinguished road
Default

Hmm, I tried that and now the Case Management software reads it as an invalid code. I suspect it's the CM software that's screwing up the formatting, so I will give their helpdesk a call.

Thanks for trying though Macropod.
Reply With Quote
  #4  
Old 09-27-2012, 03:19 AM
macropod's Avatar
macropod macropod is online now Merge Field Formatting Windows 7 64bit Merge Field Formatting Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

That suggests your CM software isn't performing a mailmerge, but is instead simply using the mergefields as placeholders. In that case, you should be able to obtain the desired result by defining an appropriate Character Style, then applying that Style to the mergefield and whatever character follows it.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 10-08-2012, 03:38 AM
Welshie82 Welshie82 is offline Merge Field Formatting Windows 7 32bit Merge Field Formatting Office 2007
Advanced Beginner
Merge Field Formatting
 
Join Date: Oct 2011
Location: Birmingham
Posts: 33
Welshie82 is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
That suggests your CM software isn't performing a mailmerge, but is instead simply using the mergefields as placeholders. In that case, you should be able to obtain the desired result by defining an appropriate Character Style, then applying that Style to the mergefield and whatever character follows it.
Yes, that worked, thanks Macropod (as always)!
Reply With Quote
Reply

Tags
merge field, word 2007

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Merge Field Formatting Character Count in Merge Field deddy Mail Merge 3 10-20-2011 02:20 AM
Text form field loses formatting in Word 2010 mel72349 Word 0 08-02-2011 02:25 PM
Merge Field Formatting Merge field in header disappearing Medievalguy88 Word 2 01-06-2011 08:19 AM
merge field formatting problem with "text to be inserted before" wissam Mail Merge 0 12-13-2009 12:50 AM
Merge Field Formatting Text Form Field formatting problem Toshii Word 1 06-08-2009 07:21 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:03 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft