Walter, you have to set Outlook up with AN account. It doesn't have to be your work email (although it can be). You can even get a temp Outlook.com or Hotmail account and use that for sending messages. Once that's configured, you'll be able to send with Outlook.

I am set up with an account , which i do use for emailing with outlook 365. but it looks like Access doesn't think that its the default on my work computer.   Just tried it on my home computer which i also use for work and Access training & it works on that one. But it doesn't work on my work computer which has the same outlook 365 settings

Since I can't see your computer, I'm not sure what the problem is. Perhaps your work computer has some unique settings or was configured by your IT guys to not allow outside email. I don't know. Could be a million things.

I would make sure that Outlook is set as your default Mail handler because in windows 10, the default is windows mail. You might use Outlook BUT if windows mail is the default handler, which isn't set up, access will use that one. Search google for 'Change default email app in windows'

Yeah, that too. I thought when you installed Office and ran Outlook for the first time it asked if you wanted to make Outlook your default mail handler... but I could be crazy...

Hi Walter, on Windows 10, go to Start, Settings, Apps, Default Apps, and set the default mail app to Outlook.

I made a mass-email Access database a long while ago on Windows 7 and Access 2007.  I don't recall the need to set Outlook as default, however.  But maybe it's different now (or maybe I misremember).

My mass-email app also could not send too many messages at once, otherwise I would be blocked as a spammer by the email service providers at the receiving ends, sometimes by my email service provider as well.  I had to set my app to send only 10 messages or so every N minutes, then pause for another M minutes before sending again.

Yeah, in my Email Seminar, I show how to time them to space them out. Google doesn't let you send more than 500 per day, so you can put a 30 second timer between emails and it works fine. You can send either through Gmail directly (using SMTP) or Outlook, but from what I understand at the end of this month Google is removing the ability to send thru "less secure" email programs, so that means it might stop working with Gmail.

Thanx! Ya'll Will try that on Monday when i am back in the Office , it does work on my home computer which is networked together with my shop/work computer.

Walter, I just tried, and I was able to send mail with VBA *without* having Outlook as my default mail app in Windows settings.  If Outlook is working on your PC (try sending some test mail), Access should be able to work with it.

Here is the exact code I used (except my email address), written many years ago, and it is basically identical to Richard's:

Dim oMsg As Outlook.MailItem
Set oMsg = Outlook.Application.CreateItem(Outlook.OlItemType.olMailItem)
oMsg.Subject = "test1"
oMsg.Body = "Hello World"
oMsg.To = "[email protected]"
oMsg.Send
Set oMsg = Nothing

I do need to be able to use outlook on this project , cause the access program will be used by a few personal on shop floor & office personal, communicating via email / we all use outlook as our default email. also access will be sending auto emails when certain item(s) get low in stock.