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
Bookmarks