Microsoft References Needed For SendObject

[lhooker]

What Microsoft Access references (in the Object Library) are needed to send e-mails (Outlook, Gmail, Yahoo . . . etc.) with the SendObject command ?

 

[Gasman]

Why not try a search?, even here?

SendObject for email references needed

What references are required to use sendobject for purpose of sending email? thanks, vmon

www.access-programmers.co.uk

or here

SendObject Method [Access 2003 VBA Language Reference]

learn.microsoft.com

It is just the Access program itself I believe.

 

[theDBguy]

The default references should be all you need. However, SendObject will simply invoke your default mail client. So, make sure you have one.

 

[tvanstiphout]

What Microsoft Access references (in the Object Library) are needed to send e-mails (Outlook, Gmail, Yahoo . . . etc.) with the SendObject command ?

What is the bigger picture? Did you switch to New Outlook perhaps, and that stopped SendObject from working?

 

[lhooker]

Tom,
I'm running Outlook 2016. My problem is that my e-mail sent by the MS Access SendObject command is arriving days latter. I had this problem before, but I can't remember how I fixed it. I vaguely remember selecting an additional reference (from the Object Library). I can't remember which DB had this problem. Thanks ! ! !

 

[lhooker]

Here are my references.

 

[GPGeorge]

Tom,
I'm running Outlook 2016. My problem is that my e-mail sent by the MS Access SendObject command is arriving days latter. I had this problem before, but I can't remember how I fixed it. I vaguely remember selecting an additional reference (from the Object Library). I can't remember which DB had this problem. Thanks ! ! !

This would have been a great way to introduce the problem and provide a context for potential answers.

The fact of the matter is, it seems, that the email does get sent. It does arrive at the destination. There's probably nothing wrong in the accdb. It might be in Outlook, your email server, or even the email server of the recipient who eventually does receive your email.

Lots of moving parts beyond the Access accdb to be investigated here.

 

[lhooker]

GPGeorge,

This even happens when sending to myself. Any suggestions ?

 

[GPGeorge]

Your email server appears to be the bottleneck then. What anti-virus software is running? Are there rules about acceptable content in your organization's email?

The fact remains that Access is sending out the emails, does it not? And that means looking outside Access for possible problems.

 

[theDBguy]

Tom,
I'm running Outlook 2016. My problem is that my e-mail sent by the MS Access SendObject command is arriving days latter. I had this problem before, but I can't remember how I fixed it. I vaguely remember selecting an additional reference (from the Object Library). I can't remember which DB had this problem. Thanks ! ! !

Can you show us your SendObject code? Does it have a True argument at the end?

 

[lhooker]

I figured out what is happening with my delayed e-mails. It is due to Microsoft Outlook's "Delay Delivery" option. You can locate it by opening an e-mail, click on "Options", then click on "Delay Delivery". Locate the "Delivery options" section and uncheck the "Do not deliver before" box. When I unchecked this box, then I was able to receive several sent e-mails (via SendObject) immediately. I can't figure out how to change this options in Microsoft Access. Any ideas ?

 

[GPGeorge]

I figured out what is happening with my delayed e-mails. It is due to Microsoft Outlook's "Delay Delivery" option. You can locate it by opening an e-mail, click on "Options", then click on "Delay Delivery". Locate the "Delivery options" section and uncheck the "Do not deliver before" box. When I unchecked this box, then I was able to receive several sent e-mails (via SendObject) immediately. I can't figure out how to change this options in Microsoft Access. Any ideas ?

Can't you set it in Outlook globally and not need to do anything in Access about it?

 

[lhooker]

George,

I'm not sure. Also, how would I set up Outlook globally (via VBA) ?

 

[The_Doc_Man]

First, this is a client action because it holds the message in the Outbox until the scheduled time.

Second, because it refers only to local boxes, it is therefore a local setting. This is not a property of the .PST (postoffice) file but rather is a property of an individual user profile.

One of the hints I ran across in the search was that you could make a "permanent" rule to this effect. Check your "rules and alerts" area to see if you have a rule that delays the transition from Outbox to Sent OR delays the transition from Drafts to Outbox.

You can look up this topic online using the "Outlook Delay Delivery" search string. Be warned that depending "Old" or "New" Outlook, your answers can be different.