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 / Programming / June 2007

Tip: Looking for answers? Try searching our database.

Word Mailmerge format change mid-field

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Mike Trout - 08 Jun 2007 22:06 GMT
Using Word 2003.  I have a series of contracts and other documents that are
created using a Word mailmerge from a dBase .dbf file.  The dbf is in
Version 4 format. (at least, I'm told it's in db4 format - my old copy of
dBase 5 for DOS opens it fine, so it isn't in anything newer than V. 5
format)

In many of the documents, the name, address, etc. fields change
typestyle/format mid-field.  For example, the address "12345 W. Wagon Wheel
Drive"  The "12345" is in 11pt Times New Roman , and "W. Wagon Wheel Drive"
is in 12pt Arial Bold.  (point sizes approx. from printed page)  On another
field the name "George Jetson" has "George" in 11pt Times New Roman and
"Jetson" is in 12pt Arial Bold.  Most of the documents have the 'normal'
font set to 11pt Times New Roman Bold, but some are just 11pt Times New
Roman.  It appears the first word of the inserted field matches the rest of
the document's format and then the format changes mid-field.  In my base
documents, the name is repeated correctly in Arial 10pt (by design) in the
header, and it comes out correct, but in the text of the contract the name
(which is supposed to be the style of the body text) is mixed up.

I wonder if there's some hidden format changes in the original document I
can't see?  The merge field codes itself matches the format of the rest of
the document (as it should), but when merged and printed (automatically by
the program - I suppose I could change my program so it doesn't print, it
just stops but I haven't yet) I get the odd formatting.

Is there some way to see if there is odd formatting?  (Like the old word
Perfect had 'reveal codes' where you could see every formatting code)

Thanks for any help and/or ideas.

Mike.
Cindy M. - 09 Jun 2007 14:30 GMT
Hi Mike,

In the main merge document press Alt+F9 to toggle on the field codes. Do you
see \* MergeFormat at the end of the mergefields that display such problems?
If you do, try changing that to \* CharFormat and see if the problem goes
away?

> Using Word 2003.  I have a series of contracts and other documents that are
> created using a Word mailmerge from a dBase .dbf file.  The dbf is in
[quoted text clipped - 14 lines]
> header, and it comes out correct, but in the text of the contract the name
> (which is supposed to be the style of the body text) is mixed up.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)
Mike Trout - 11 Jun 2007 22:45 GMT
Thanks, Cindy.

That appears to have worked.  Now to go change 300-some-odd contracts &
forms... :-\

Mike.

> Hi Mike,
>
[quoted text clipped - 4 lines]
> If you do, try changing that to \* CharFormat and see if the problem goes
> away?
Doug Robbins - Word MVP - 10 Jun 2007 01:09 GMT
In addition to Cindy's advice, after adding the charformat switch, you can
force the formatting that you want by applying it to the M of MERGEFIELD.

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 Word 2003.  I have a series of contracts and other documents that
> are created using a Word mailmerge from a dBase .dbf file.  The dbf is in
[quoted text clipped - 28 lines]
>
> Mike.
Mike Trout - 11 Jun 2007 22:46 GMT
Thanks for the tip, Doug.  Good to know should I need to do that.

Mike.
> In addition to Cindy's advice, after adding the charformat switch, you can
> force the formatting that you want by applying it to the M of MERGEFIELD.
 
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.