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

[islander]

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-]

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

 

[Guest]

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.