thanks John - it's already been resolved ... ta 🙂

ta - I added where SI.Deliverynote is null to that top query and I've got some records back.

I would expect to get at least a few as we're constantly raising...

there are some null deliverynote entries in SI - where an invoice has been raised directly. that shouldn't be the case here ..

I've got a deliverynote that says it's been...

I'd run that through a VB script then - you can run the SQL query - output to a file and then use VB to set up the email to...

Are you saying that outputting HTML from SQL doesn't email well?

and the resolve you need to do is to put the HTML into a file and email the file ?

Not to worry - I've resolved the issue.

line in script now reads

DSN="Driver={SQL Server};Server=<PUBLICIP>,443;Database=<DBNAME>;UID=<USERID>;PWD=<PASSWORD>"

I've used the standalone firewall to open 443 to just our website host IP address and I use...

Why don't you do it in 2 hops ...

export the data EXCLUDING the memo field - import that ...

then connect to the SQL server in access and update the records...