How do I retain formatting from an Excel Data File to a Word Merg.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am merging an Excel File with a Word Document (Word 2002). For years in
the past I've had no problem but now the Excel Formatting is not retained.
How do I get the Word Document to retain the Excel formatting?

Thanks for your help.
 
How exactly are you "merging" the Excel content into the Word doc?

If you try Insert>Object>Create From File & then specify the Excel file
involved, the Excel formatting should be retained.

Otherwise it is probably being inserted as a Word Table which would account
for the loss of formatting.

HTH |:>)
 
CyberTaz said:
How exactly are you "merging" the Excel content into the Word doc?

If you try Insert>Object>Create From File & then specify the Excel file
involved, the Excel formatting should be retained.

Otherwise it is probably being inserted as a Word Table which would account
for the loss of formatting.

HTH |:>)
Click to expand...
 
CyberTaz said:
How exactly are you "merging" the Excel content into the Word doc?

If you try Insert>Object>Create From File & then specify the Excel file
involved, the Excel formatting should be retained.

Otherwise it is probably being inserted as a Word Table which would account
for the loss of formatting.

HTH |:>)
Click to expand...

CyberTaz,

I am using the Merge Wizard. The Word document has MergeFields inserted (row
1 of the Excel file). In Word 2000 the formatting is retained but in Word
2002 it is not.

Pookas
 
Back
Top