Hi,
I have a problem that I hope someone will be able to help with.
I have a Word document template that mail merges from a spreadsheet. This works fine.
My problem is that I need to format the colour of some of the text in the mail merged document. I could format the text in the correct colour manually but there are 100's of recipients and it would be very time consuming.
The text in the spreadsheet is formatted in the correct colour but when I mail merge, the text defaults to black.
Would I need to write some VBA code in the excel spreadsheet to deal with this or does the text need to reformatted somehow in the completed mail merge document using code?
I can attach some dummy data in a spreadsheet with the document template if this helps.
Thanks for looking.
Bookmarks