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

Tip: Looking for answers? Try searching our database.

How to mailmerge formatted text from a Exel to Word document?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
islander - 20 May 2005 15:45 GMT
When I mailmerge formatted (i.e. italic/underlined/bold) text from an Excel
document to a Word document the formatting disappears. I would like to know
if it is possible to keep the formatting in the mailmerge process?
Cindy M  -WordMVP- - 22 May 2005 08:02 GMT
Hi =?Utf-8?B?aXNsYW5kZXI=?=,

> When I mailmerge formatted (i.e. italic/underlined/bold) text from an Excel
> document to a Word document the formatting disappears. I would like to know
> if it is possible to keep the formatting in the mailmerge process?

You can only do this if the data source is a Word table. You should be able to
copy/paste the Excel data into a Word document, if it doesn't have more than
63 columns. (Note: set up the page layout to landscape orientation, and go
into Normal view to have the best chance of SEEING everything you paste.)

Once you've done this, you can set up the main merge document. Insert all the
merge fields. Now select each merge field that should bring across the
formatting and press Shift+F9 to toggle on the field code. Remove the term
MERGEFIELD from the code. Press Shift+F9 again to hide the field code.

Note: you must leave at least one MERGEFIELD intact or mail merge will not
execute.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
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 :-)
larrynospam@nospamjbmsystems.com - 24 May 2005 15:57 GMT
OctoTools, a document management software ( www.octotools.com ) which is
used to format, enhance, print and output pdf/electronic files also has a
mail-merge and supports Rich Text Format documents (with bold, Italic,
underline, images, and so on...).  It is designed to run automatically with
medium to high volume throughput.  If interested, please get in touch.
Larry T. at 978 535-7676

Regards,

Larry T.
 
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.