Yeah, if I had a nickel for every time Google changed one of their screens or Microsoft changed something like that, I could buy myself a pretty expensive steak dinner. It's impossible to keep up with the changes, so I just have to leave it up to the student to try to figure out what's going on based on the video. As far as the AccountT goes, that's if you want to set up multiple accounts and be able to send email from using your mail server that you're building.

The text associated with this screenshot did not get transmitted due to operator error. I followed the Gmail App Password video. I am trying to modify the final New Bulk mail database. I figure all I need to change to make it work using your text is substitute my Gmail address, Gmail password, and from Gmail address. I subsitiued my email address in CustomerT. I did all of the above in the VBA code. I get the error show in the screenshot. Is my logic sound, and where all do I need to make substitutions. I am not trying to build my own server. I am lost after 3 times in the course. I am misunderstanding something. I do meet all the prerequisites. Any help would be appreciated. This course is absolutely amazing!

See if this video helps you: Overflow!

Personally, I've never seen an overflow error while sending email and I use this exact code myself in my database still to this day with almost no modifications.