Recent content by upnorth

Yes, the app password created does contain spaces. Update. I have got this to work with a gmail.com account but not with an outlook.com account Any thoughts on why ?

Thanks for that reply. Created an app password, tried changing ports, still no success. App password includes spaces, assume they stay in ?

Thanks for the reply Suggestions for plan B would be ?

Returning to this thread after 9 years :love:- Have used this to send emails from a MS Access database for 9 years. The send using has just been changed to OAuth2 Can CDO deal with that ? David TIA

Thanks for comments so far. With staff holiday`s & this being the new year weekend I`m going to have to leave this till end of next week Best wishes for 2024

People ! ;) A user who is prone to being impatient if he is under pressure. Hence my initial thought, the simple solution was to prevent multiple clicks of the button

Thanks everyone for the suggestions. Does suggest that clicking the button more than once is causing the intermitent problem. @ebs17 yes it makes sense to check the data I`ve checked & the unique record number from the sales table is one of the fields the update query drops into the preinvoice...

Thanks for the replies. @The_Doc_Man s reply saying code instructions are queued puts my theory for the cause of the problem out of the window.? Anyway, finishing time, back tomorrow.

Good evening I Have an access database in use for about 15 years with minimal probs running our bottled milk business From the home page a button opens a form where invoices can be created. As the form opens a query grabs data from the sales tbl & drops it into the preinvoice tbl then a query...

The example code in Gina`s post above sends through gmail. I played about and found changing the SMPT server names , port number, user name & password it would work through my Bt email. - So you don`t need a gmail account to use it Impressed !

Solved it ! Quotation marks after text body were the problem Working fine now

Thanks for that I can get it to create and send an email However the message body comes like this - strSubject & vbNewLine & strspareline & vbNewLine & strMessage & vbNewLine Can anyone see why this is happening TIA David My code below Private Sub Command87_Click() If...

I have the code below which creates an email to Outlook. I would like to use CDO to email but can not figure out how to incorporate CDO code into this Any help would be much appreciated David Private Sub Command68_Click() On Error GoTo Handler If DCount("[dob]", "[cpp12q]") = 0 Then MsgBox...