Hi!
I need help on MS Word Macro in VBA. I spend many hours per every year painting stupid tables representing refrigerators in MS Word. I have tried to program a VBA Macro to do it instead of me, but due to my poor programing skills, so far with no success.
It is not easy to explain what I need, that's why I have prepared simplified MS Word file for better explanation.
Basically: I prepare all data in MS Access, than I transfer it to the MS Word file(s) using mailmerge. So far so good. But I need some conditional formatting in MS Word file after that, and moreover: I need to use mailmerge field as condition. And that is the core of my problem.
My idea is, to do it with MS Word Macro, but it is also possible to prepare some calculations in MS Access before, if needed. Please see attached MS Word file. It's everything explained there. On the first page is the START POINT, and on the second page the RESULT.
I am using Office 2010.
I really appreciate your effort on my problem. Thanks in advance!