I am developing a system that assesses results in Excel and sends out emails to students. The text in the emails has to contain hyperlinks and the users will want to change the standard text blocks fairly often. Therefore, I have put the text into Table Cells in a Word Document. The Excel part of the program works fine and it is calling the right cell content in the Word document. The problem is that I cannot copy and paste or transfer just the contentthe cell(keeping the original hyperlinks in the text but not the cell itself) into the body of the automatically created email message. I have managed to get it to place the text from the Word cell into the email but this loses the hyperlinks. I have also tried Inspector and WordEditor related code but this does not seem work either (perhaps I am missing something). If someone could please give me some advice it will be very much appreciated. Thank you in advance for your assistance.
Reply With Quote
