You can make a start with Excel’s VBA. The core of the language is common across the MS Office applications. However, each of these applications (Excel, Word, etc) has a different underlying data model, and you will have to learn how to use VBA in each one - this would be true even if you went straight to learning VB.NET. An advantage of starting with Excel is your familiarity with the what the application does and what you expect (although, you will assuredly bang your head against the metaphorical wall quite a few times when it doesn’t do what you expect). You also don’t have to worry too much about building an application, as that’s been done for you. On opening Excel, you should have a blank worksheet ready to play with and can, for example, write simple commands using just the Immediate window in the VBA Editor. Do a web search on “Excel VBA tutorial” or similar to find suitable beginners’ courses. I know Udemy do one and there’s a very brief introduction here Getting Started with VBA in Excel 2010 The macro recorder can be useful when trying to get an idea how to do something in particular (such as set a cell’s background colour), but I don’t find it of much use in learning how best to solve a problem in VBA. I recommend setting yourself specific small goals (such as setting some attribute of a cell, or filling part of a column with random numbers) and then working out how to get there by a combination of recorder, Help, tutorials and asking questions on Quora or other programming site.
CDO works by sending an email to a list of addresses you specify. You can easily create a list for this by using the same script you have just read for finding the IP address manually. Once the list is established use the misaddresses() function to populate it with the addresses. This is essentially a single line of VBScript with a variable and a function. Here’s what the first line looks like, without a variable. Note the first line contains a single word “IF” (as in IF there are problems with the connection). You have now learned how to use this line within your scripts. Using the command prompt in the MS-Windows environment to read this line (without using a variable and a function), you will see this: Now we know that reading an IP address in a text file is fairly easy, but getting around the limitations of Internet.