Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / January 2008

Tip: Looking for answers? Try searching our database.

how to bold a line in mail merge labels

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
toconnor - 10 Jan 2008 19:16 GMT
using an excel spreadsheet I have the company name field bolded but when I
create my labels the bold doesn't happen. i have office 2000
Peter Jamieson - 10 Jan 2008 19:58 GMT
The bold (and other such formatting) in Excel doesn't get through to Word.

If you are inserting your Excel data using an "ADDRESSBLOCK" field in Word,
you are probably out of luck, because I don't think you will be able to bold
a specific line successfully.

If you use individual fields to insert the data, you can select the field,
apply /Word's/ bold setting, and if necessary, use Alt-F9 to view the field
codes, then change

{ MERGEFIELD myfield }
or
{ MERGEFIELD myfield \*mergeformat }

to
{ MERGEFIELD myfield \*charformat }

If you have bolded /some/ of your comany names and you want the bolding to
get through to Word selectively, then you have to consider having an extra
column in Excel (let's call it "boldcompany") and set it to "Y" if the
company name should be bolded. then do something like

{ IF "{ MERGEFIELD boldcompany }" = "Y"
"{ MERGEFIELD company \*charformat }"
"{ MERGEFIELD company \*charformat }" }

and apply the appropriate formatting to each of those "{ MERGEFIELD company
\*charformat }" fields.

Signature

Peter Jamieson
http://tips.pjmsn.me.uk

> using an excel spreadsheet I have the company name field bolded but when I
> create my labels the bold doesn't happen. i have office 2000
Doug Robbins - Word MVP - 10 Jan 2008 20:05 GMT
In the mail merge main document, press Alt+F9 to toggle on the display of
the field codes and if there is a \mergeformat switch at the end of the
company name merge field, remove it and replace it (or add, if it is not
there) a \charformat switch, and then apply bold formatting to the M of
Mergefield.  Use Alt+F9 again to toggle off the display of the field codes.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> using an excel spreadsheet I have the company name field bolded but when I
> create my labels the bold doesn't happen. i have office 2000
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.