If you macro works for one email, but not the next, this indicates that you encounter the changing tags/IDs web scraping challenge.
Solution: See Scrape text - Changing id (the FAQ talks about clicking a button, but the issue is the same)
If you do not want to learn XPath (tricky stuff), I recommend that you extract the data visually with OCR. => See screen scraping. The OCR Extract Relative command is what should work well here. Use e. g. the “Address” word as anchor image.