Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 09-26-2012, 06:24 AM
Welshie82 Welshie82 is offline Windows 7 32bit Office 2007
Advanced Beginner
 
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 offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 10,529
macropod is a jewel in the roughmacropod is a jewel in the roughmacropod is a jewel in the roughmacropod is a jewel in the rough
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
[MS MVP - Word]
Reply With Quote
  #3  
Old 09-27-2012, 02:30 AM
Welshie82 Welshie82 is offline Windows 7 32bit Office 2007
Advanced Beginner
 
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 offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 10,529
macropod is a jewel in the roughmacropod is a jewel in the roughmacropod is a jewel in the roughmacropod is a jewel in the rough
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
[MS MVP - Word]
Reply With Quote
  #5  
Old 10-08-2012, 03:38 AM
Welshie82 Welshie82 is offline Windows 7 32bit Office 2007
Advanced Beginner
 
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
Please reply to this thread with any new information or opinions.

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
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 in header disappearing Medievalguy88 Word 2 01-06-2011 07:19 AM
merge field formatting problem with "text to be inserted before" wissam Word 0 12-12-2009 11:50 PM
Text Form Field formatting problem Toshii Word VBA 1 06-08-2009 07:21 PM


All times are GMT -8. The time now is 12:24 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft