Last seen: May 7, 2025
@Hans Hallebeek, I honestly don't know if it will work on my live data. I tried to use the macro on a copy of my workbook, and I just had the "spi...
@Hans Hallebeek, I am somewhat new to VBA and do not understand how to debug and step thru the code as of yet. Attached is a sample file. I left...
@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...