Recent content by johnbtic

Used VBA for Outlook in the end works a treat. Thanks for all the help much appreciated :) John

Hey DBGuy it works for sending emails which is handy. I'm looking to cycle through the gmail folders and delete certain emails. Not sure how that'll work.

Found this link for sending gmails using VBA, seemed to work https://learndataanalysis.org/send-email-from-your-gmail-account-with-vba/

What I think is interesting as well is that the VBA command is just when it's trying to connect to Outlook it's not like it's trying to create or send an email...

Does anyone know of a way to write code directly to gmail? I tried to do that originally and couldn't do it so I figured I'd write to Outlook instead.

So it worked great. I figured it was because I let Outlook properly synchronize with gmail, just one email address now in Outlook as opposed to 3 earlier. Now it's not working again. Same error. I can send an email in Outlook but the code isn't working.

Thanks DBGuy that was it. You ARE a genius! I have a dim and distant memory of seeing this a while back. I have multiple email addresses in my Outlook. So I removed them all and just added in this one and was able to send emails. It still didn't work, I think because it was downloading all...

I think you might be some kind of a genius... I just tried to send an email and I can't find it in the send folders. I'll investigate and get back to you thanks!!!

Hi DBguy Here's the picture

Hello all Getting the above error. It used to work and now doesn't. ' Initiate Outlook Dim oApp As Outlook.Application Dim oMail As MailItem Set oApp = CreateObject("Outlook.application") Error occurs on the final line above. Many thanks for any help that can be provided...

Thanks DBGuy and thanks so much for your rapid response it's much appreciated :) I'm sure I'll be back!!

For the record here's the code Dim strProp As String, strSQL As String Dim thisDB As DAO.Database Dim thisRS As DAO.Recordset Set thisDB = CurrentDb() Set thisRS = thisDB.OpenRecordset("SELECT * FROM qryPropertiesTabular") ' Take button click from frmManagePeople, search text in textbox in...

I've been struggling with this for weeks and on a whim I just tried something and it worked. The command I was using was Set thisRS = thisDB.OpenRecordset("SELECT * FROM qryPropertiesTabular ORDER BY [tblProperties.ID]") And I removed the ORDER BY and used Set thisRS =...

Hi all I'd like to use a combobox to select a record. Then using the contents of the combobox to find a record in a recordset, this piece seems to work. But when I use the following command Set FormABC.Recordset = thisRS The contents of the bound text boxes on the form produce a '#Name?'...

Hi Mihail Okay I'll provide a little more detail. Basically it's a query made of two tables. Each entry in the query relates to a piece of work and invoices are sent once monthly so if there are several pieces of work for one client in one month, these several pieces need to go into a report...