I'm not quite sure what you were expecting, so let me rephrase my answer to you.
My problem is how to manipulate WORD and EXCEL from within OUTLOOK.
My response is:
To manipulate Word and Excel from within Outlook, you must write a custom Visual Basic for Applications program.
There are two reasons why I chose this answer.
1) It answers the question.
- If you already knew this, you wouldn't have asked this question. You would have asked an entirely different question. I'm surprised that you equate it to instructions to turn on your PC, because I'm certain you know how to do that.
- I thought that perhaps you weren't aware that you could use VBA in Outlook because it doesn't appear on the menu bar by default, so I gave you instructions to activate it on the menu bar.
- I also provided you with a link to an article that discusses how you write VBA programs in Outlook. It also links to broader VBA documentation and how you use it in Word and Excel. The article is about as relevant to your question as you can get.
Instructions for how to write a custom VBA application in Outlook to manipulate Word and Excel files is far beyond the scope of this question (which I get paid $10 to answer, and only if you accept the answer).
2) There's really no answer in between. For example, when you say:
String2(n), is found and used to pick up addressees, ADD1(n) and ADD2(n), from an EXCEL workbook
the most I can tell you is pretty obvious:
- You need to find a way to find String2, for example by searching with a regular expression for fixed content that's always in place.
- Then you will have to open the Excel workbook you reference
- Then you have to somehow perform a search for addresses.
You haven't provided enough information to tell you anything other than that:
- You haven't said what String2 is (person's name, company name);
- You haven't described where the Excel workbook is, what data it contains or what the structure of the workbook is;
- You haven't given any detail about ADD1 and ADD2 and how you can "pick them up."
There's nothing else I can tell you. The application you're describing is not trivial and will require a substantial amount of work. If you don't know how to write VBA applications in Outlook that maniupulate Word and Excel, your best bet is to hire someone who does.
Thank you and have a good day.