![]() OK, so I thought I would try my luck and just quickly make one attempt to get an old CDO gmail send code of mine to work again. I ask because, as I already mentioned, this can effect how the coding works and what parameter settings are required, ) If you don‘t want to share this information publicly in this post, you can tell me via Private message. _ ( I assume you are in Texas, USA? - and have registered the gmail accounts and tried to use the codings there? If this is not the case, then can you tell me what is your country. _ if you have a spare free gmail account, registered in a similar way to the main gmail that you finally want to use, and care to share the username and password with me via private message, then if I get my coding working, I can also test that account: Once again this is because as I mentioned, who registered an account and where it was registered, effects what and how gmail accounts can be used in CDO based coding: ( I have no experience with Outlook based coding so cannot help, but someone else may be able to give you an alternative outlook based codoing ) _ Many people use Outlook based coding rather than CDO based coding. Those German Telekom accounts almost always work by anyone, anywhere. Finally, as a last resort, for the occasions that no gmail account works, it tries one or more of my German Telekom accounts. ![]() My best solution to date involves a coding that loops through a few gmail accounts, also sometimes trying them with slightly different parameters in the codings. ![]() Some work better and more consistently than others. Despite having identical settings, some accounts work differently in the codings and occasionally require different settings. Some of my accounts and some of my codings have been registered by, and used by, people in different countries. Issues of your country of origin can also come in. Gmail, and Google generally, like to conrol different people in different ways. Some of these are caused by reasons we cannot know fully:, beacuse. _ I have always experienced problems with gmail accounts in these sorts of codings. Just some things to bear in mind in the meantime I expect I probably will sort it out eventually,īut it may take a few days as I am busy on other things just now. I will report back here if I make any progress. I shall keep looking into this, because I want my CDO send codings to work again with gmail. So it would appear that G Mail are now requiring something similar ) Then I find that the codings are much more stable and reliable ( To use a German Freemail, xxxx account in such CDO send Mail codings, one has always needed to create a seperate additiopnal password to use in the coding. However, when I use identical codings, but use a If I make any progress I will report backīy the way, In the past I have often experienced various problems using gmail accounts in these CDO sending type codings. We now need to arrange a different password, an additional one to our normal password. Indeed it would appear that GMail have changed things, On testing some of my older CDO send mail codings, I find now that they are no longer working. ![]() Set dlgFile = Application.FileDialog(msoFileDialogFilePicker)įor Each strItem In dlgFile.SelectedItems 'select the file(s) to send with the microsoft file dialog box VbNewLine & Sheets("Sheet1").Range("A3").Value ![]() From = Sheets("Sheet1").Range("A1").Value 'email address Subject = Sheets("Sheet1").Range("D3").Value 'set the email properties and the file to send 'Set your username and password for your own gmail account here 'Make SMTP authentication Enabled=true (1) Code: Select all Private Sub CommandButton1_Click() ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |