I am attempting to auto generate and send e-mails via MS Access. I have VBA code to do this through Outlook but I want to do it using my Rogers Yahoo e-mail, because my app password for Outlook is not working and I cannot generate a new one.
I've used the following setting in my new code:
- oSmtp.ServerAddr = "smtp.broadband.rogers.com"
- my Rogers user id and password
- oSmtp.ServerPort = 465
- oSmtp.ConnectType = ConnectTryTLS
I keep getting a connection error “Error with connecting server, Failed to read response from; 00002746 An existing connection was forcibly closed by the remote host.” Please help.
