Recent content by Harris@Z

Hi Colin, Thanks for your contribution! I did comment out .Configuration.Load-1 with no effect on the result. Interestingly, I uploaded my database to a computer in the USA a few minutes ago, and the test email failed. In other words, code not influenced by my fiber/internet provider. I am...

@pbaldy Thank you for the link. This is the site I originally looked at when developing my code. I tried to code now again, and unfortunately fails to work. @Minty Thanks for the link too. I use CDO Email Tester to check whether my parameters work, and they were successfully working till...

Hi The Doc Man, Much appreciated, thank you! Lots of information to assess and to check. I do not think it is these three for I have assessed, checked, and thoroughly discounted these as possibilities: 1. Incorrect SMTP server / port 2. Incorrect login/password 3. FROM address not valid...

Hi all, Wonder if anyone can give input why I am getting an error, or what may have changed. I have been using the code below in Microsoft Access DB for years to connect to smtp.office365.com and send emails. Out of the blue, around 4 weeks ago, I started receiving an error: "transport failed...

Hi @arnelgp Is it possible to return the intermediate value, i.e., #text# #strings# #VBA Function# as individual values rather than in one go? Thanks! Harris

@MajP - Thanks, I am aware of the VBA Split() function but could work out how to extract 'all from the string. @arnelgp - You are a star! This is perfect, thank you! I found something similar doing a Google search, but the function only drew the first instance from the string. Much...

Hi, I hope someone can assist - I have searched Google and cannot find a function that could do this for me. I would like to find a function that can extract all text between two 'delimiters' in a string. In other words: String = "Easily extract #text# between two #strings# with this #VBA...

Thanks very much for the potential solutions! And particularly for the code, much appreciated. I would not have considered these possibilities at all.

Thanks, the '#' column is not necessary to capture Using .HTMLBody is also an interesting idea! You are correct, lots of trial and error! At the moment, more like error

Thanks for your potential help! I have forwarded the example to your email address. Thank you Harris

Hi all, I hope that someone can help this novice programmer with vba to import the following table. The data arrives in an email table, and we copy and paste into a text box. The code needs to extract the data and import into an Access table. I appreciate that the table will have 5 fields which...

Thanks for further input. I tried Val() to no benefit. Regarding "string of varying length", the data set I now deal with are those all preceded by "2004/" hence my condition, and all values following are 5 characters (numbers), e.g., 00001, 10001, 12345

Following some suggestions here, I created a query without the order by, saved it, and then did a second query sorting by the Sec field, and this appears to have worked!

I have no control over the data. This is how it is stored in Quickbooks Online, and I am linked via ODBC to this data via my Access database. I cannot change what has been previously inputted. So I am trying to find a way around this. Interestingly, if I click the sort descending in the...

Thanks for your inputs. The field DocNumber, contains invoice numbers. It is a string field with values such as 2024/1543, 2024/1544, etc. However, occasionally contains a value without the "2024/" part I am trying to extract the 'highest' invoice number used. So I have created a field to show...