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 / April 2005

Tip: Looking for answers? Try searching our database.

Retain original formatting

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Phil Shortell - 19 Apr 2005 17:09 GMT
Word 2003
I am trying to perform a mail merge from an Excel data source where SOME of
the reords contain a field where the first character is underlined.  This
underline is significant.  I can of course force all first characters of a
mergefield to be underlined but that is not the need.
How do I retain character formatting form the DATA SOURCE?
Signature

Phil Shortell

Peter Jamieson - 19 Apr 2005 18:13 GMT
I've seen one suggestion on how to do this directly from an Excel file, but
frankly, I wouldn't bother.

I suggest that you try the following:
a. Select/Copy/paste your Excel sheet into a Word document, choosing a
format that retains the formatting you want. I think one of the options that
ends up as a table will do.
b. use the Word document as the data source, but instead of using
MERGEFIELD fields to insert the data, use { REF } fields. In fact, you may
have to go slightly further than that, e.g. if you have a field named
"myname", you may need to use

{ myname }

rather than

{ REF myname }

If so, you need to avoid using fuield names that clash with standard Word
field type names such as REF, MERGEFIELD, FILENAME, SUBJECT etc.

If that works, but you need the process to be simpler than that for end
users, as far as I can tell it should be possible to write a macro to do it
but I don't have any code for that myself.

Peter Jamieson
> Word 2003
> I am trying to perform a mail merge from an Excel data source where SOME
[quoted text clipped - 3 lines]
> mergefield to be underlined but that is not the need.
> How do I retain character formatting form the DATA SOURCE?

Rate this thread:






 
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.