In essence, that kind of formatting does not come across using MailMerge.
As long as your worksheet does not have more than 63 columns, you can try
a. selecting it, edit|copy
b. edit|Paste special into a Word document in a format that preserves the
formatting
c. use that as the data source
c. when you insert { MERGEFIELD } fields into your Mail Merge Main
Document, where you want the formatting, change e.g.
{ MERGEFIELD mycolumn }
to
{ REF mycolumn }
or
{ mycolumn }
This is unsupported, relies on very old Word behaviour, and is probably not
a good long-term choice, even if it works for you.
Peter Jamieson
"KCNC" <KCNC[ at ]discussions.microsoft.com> wrote in message
news:7D4B9D6B-2249-47B9-9C52-764E78558341[ at ]microsoft.com...
[Quoted Text] > Our datasource is an excel worksheet. We want the fomatting, including
> bold
> to come over into the Word document upon merging. We have not been able
> to
> find a way to preserve the bold from Excel into Word. Any ideas out
> there?
> We are in a hurry for this one...
|