Hi,

I am new to VBA programming and I'm sure that this is where the solution lies to my current problem...

I am using the "Mail Merge" option in ms Word to bring in information from a table created in Excel. Information such as Name, Surname etc. but other information is also required.

The imported information must be presented in the form of a table in Word (but cannot be an Excel table). I am looking for a VBA code/answer to this.

The issue lies in the fact that the letter "Y" denotes to a particular colour in a particular cell. Conditional formatting isn't available in ms Word.

The following photos hopefully explain my problem better. I need the word document to resemble the colour as well as the letter.

Many thanks!

Excel Table:
Excel_photo.png

Word Table:
Word_photo.png