KenRandall

Comments

• Hi Nard,
  
  I haven't been able to successfully use the sql count(distinct xxx). Is there a way?
  
  So I thought maybe I could do it in RAP instead.
  
  Any ideas?
  
  Thanks,
  
  Ken

  in Distinct Count Function Comment by KenRandall April 2023
• I would also like to be able to set the radius for a rounded rectangle.

  in TppShape.radius Comment by KenRandall March 2023
• Thanks Nico. That works but every time I run it I need to select the account to use. How do I avoid that and where is the token stored?

  in TppRESTMailOutlook365 Using without a Report Comment by KenRandall September 2022
• Hi Nico,
  
  That now works ok except it then opens an Outlook web page with the details of the email saying [Draft] This message hasn't been sent.
  
  Thanks,
  
  Ken
  
  

  in TppRESTMailOutlook365 Using without a Report Comment by KenRandall September 2022
• I tried this. It connects ok but fails to get the token. If I debug it the error message is:
  
  {"error":"invalid_request","error_description":"AADSTS900144: The request body must contain the following parameter:
  ''code''.\r\nTrace ID: …

  in TppRESTMailOutlook365 Using without a Report Comment by KenRandall September 2022
• Thanks Nico. Would be nice if you made it a component.

  in TppRESTMailOutlook365 Using without a Report Comment by KenRandall September 2022
• Thanks Nico. Is there a sample project available for doing this without using a report?

  in TppRESTMailOutlook365 Using without a Report Comment by KenRandall September 2022
• Sorry Nico, looks like it is just basic authentication is being retired on 22nd Oct.
  
  So back to my other question, how can the token be accessed?

  in TppRESTMailOutlook365 Using without a Report Comment by KenRandall September 2022
• I thought they were stopping using Rest.

  in TppRESTMailOutlook365 Using without a Report Comment by KenRandall September 2022
• I have since found that the problem was not with the report itself but that the customers IT people had set the shortcut to an old version of our software. Sorry for the inconvenience.

  in EmailSettings.ConnectionSettings.MailService Does Not Exist Comment by KenRandall March 2022
• Thanks Nico, sent via email.

  in EmailSettings.ConnectionSettings.MailService Does Not Exist Comment by KenRandall March 2022
• Hi Nico,
  
  I was unable to send an email via Outlook 2019 using extended MAPI. It just failed. It didn't get as far as the prompt. I should mention that I am using this without a report.
  
  Regards,
  
  Ken

  in TppSMTPOutlook when PreviewEmail is False Comment by KenRandall October 2021
• Please ignore the above.

  in New SMTPOutlook plug-in Comment by KenRandall July 2021
• Hi Nard,
  
  Thanks for your help. I can confirm that using ppSMTPOutlook works under these circumstances but reverting back to using ppSMTPMAPI, to be able to use multiple email clients, gives an error when Outlook.exe is running.
  
  

  in New SMTPOutlook plug-in Comment by KenRandall July 2021
• Both are running without administrative rights.

  in New SMTPOutlook plug-in Comment by KenRandall July 2021
• I have just noticed that I only get the errors if Outlook is already open!

  in New SMTPOutlook plug-in Comment by KenRandall June 2021
• Sory, - Nico

  in Auto close preview in RAP Comment by KenRandall September 2019
• Thanks Niko. Will try this.

  in Auto close preview in RAP Comment by KenRandall September 2019
• I have resolved this with the help of earlier posts to this forum. It was because Delphi was set to run as administrator but Outlook wasn't.

  in Sending Emails via Outlook 2019 Using Delphi 10.3.2 Comment by KenRandall September 2019
• Sorry agin, it is previewing in Outlook 2019 that won't work. I guess it is something to do with MAPI.

  in Sending Emails via Outlook 2019 Using Delphi 10.3.2 Comment by KenRandall September 2019
• Sorry, forget to say using RB20

  in Sending Emails via Outlook 2019 Using Delphi 10.3.2 Comment by KenRandall September 2019
• Thanks. The problem with using a Table grid is that you need to know the number of columns in advance.

  in PivotGrid Wordwrap Captions Comment by KenRandall April 2018