VBA to Outlook - Help with Looping

Hi, thanks for responding. I uploaded a sanitized version of the file I'm working with if you wouldn't mind taking a look?

Thanks so much! It is looping through the email addresses, but not the other fields. I guess I would need to reference the other cells to cycle to the next row as well. Each subsequent row in the "Replace" section has a unique entry that drops into the email body. This is probably a super simple for you , but I'm not sure how to change that reference? Could you push me past the finish line???

Thanks. Strangely enough, it's referencing the cell numbers in the email text now. Any ideas? Here's a sample:

Good Morning,

Employee U12W12 is identified as occupying space in two different buildings. We need your assistance to correct this discrepancy.

The Space Management System indicates U12 is located in X12 D12.

HR System indicates U12 is located in Y12 C12.

If X12 is the correct location, U12 will need to update the location in HR System to reflect the correct building assignment. The instructions for correcting the building assignment in HR System are included below.

If Y12 is the correct location, please respond to this email with U12 's workstation number and we will make the correction in GDI. If assistance is needed to identify the workstation number, please let us know. In order to provide assistance, please provide location details, including: floor, area, and room or suite number if applicable.
Thank you in advance for your attention to this matter.

Looping through HTML in VBA for Outlook is similar to looping through HTML in other VBA applications. The basic steps are:

Obtain the HTML source code of the email message you want to loop through. You can use the HTMLBody property of the MailItem object to get the HTML source code.

Create an instance of the MSHTML.HTMLDocument object and assign the HTML source code to its innerHTML property.

Use the various methods and properties of the MSHTML.HTMLDocument object to loop through the HTML elements and perform the desired actions.

Here is an example of how you can loop through all the links in an email message and display their URLs in the Immediate window:

Sub LoopThroughHTMLLinks()
Dim olMail As MailItem
Dim htmlDoc As MSHTML.HTMLDocument
Dim link As MSHTML.HTMLAnchorElement

Set olMail = Application.ActiveExplorer.Selection(1)
Set htmlDoc = New MSHTML.HTMLDocument

htmlDoc.body.innerHTML = olMail.HTMLBody

For Each link In htmlDoc.getElementsByTagName("a")
Debug.Print link.href
Next link
End Sub

In this example, we first obtain the HTML source code of the selected email message and assign it to the innerHTML property of the MSHTML.HTMLDocument object. We then use the getElementsByTagName method of the MSHTML.HTMLDocument object to retrieve all the <a> elements (i.e., links) in the HTML source code and loop through them using a For Each loop. Within the loop, we access the href property of each link element and display it in the Immediate window using the Debug.Print statement.

Note that you will need to add a reference to the "Microsoft HTML Object Library" in your VBA project for this code to work. To do so, go to the VBA Editor, select "Tools" from the menu bar, then "References", and check the box next to "Microsoft HTML Object Library".