I have an excel document with some cells that contain colour others which
contain background shading. I would like to be able to create a mail merge
document in word that picks up the data from this excel file and carries with
it all the cell information i.e. font size, font colour, font type,background
colour etc as well as the cell value, and places all of that information into
word. It appears as though you only get the cell value.

Any help would be greatly appreciated.