Last seen: Jan 25, 2025
@Velouria, Jackpot!!!!! Such a simple fix, I knew I was close!!!!! Thank you so very much! I have been working on this project for so very long!...
I discovered a typo in my code, I previously used this code with a loop of 100, but now I am using the Outlook max of 500. The text in red is my corr...
@Velouria, I removed that line like you said and it kind of worked. An email was generated with the template (OFT) file), however it was only 1 em...
@Velouria, Yes, that was exactly what I was attempting to do. I got that confused. Thanks so much for clarifying my error. It works great now.
@Velouria, That did not work. It display a blank in the file name. And apparently the code I chose to BROWSE is designed for file opening, not sa...
@Riny van Eekelen, I was so close on my XLOOKUP. Thanks for providing the correct solution in the XLOOKUP function. I prefer to use XLOOKUP to VL...
@Velouria, Works perfectly. And thanks for taking the time to explain it to me, now I get it. Appreciate all your help!
@Hall Hallebeek, I thought I got it, because it saved my xlsx file as the same. But when I tried on an xlsb file, it "chose" xlsx as the file type...
@Velouria, That works perfectly! I knew the answer was simple, but every attempt I made mailed. Thanks so very much for your help!!!!