Hello all! Many thanks for all the past help. Not sure if this is the correct place to post, but if not, please direct me. I have been trying for quite some time to automate a process where we have to paste statements into a word document and email each page out. I have been able to copy the contents of each page in word, open the email template and past the contents. It was suggested that I could use an Array List to pinpoint a specific line that contains the email address and paste this into the "to" field of the template. I am very new to VBA but am lost when it comes to using an arraylist. Could anyone point me into the right direction to find more information on this?
Many thanks as always!
Many thanks as always!