Search results

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

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...

GPGeorge, This even happens when sending to myself. Any suggestions ?

Here are my references.

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...

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

The below DCount statement gives me the number of duplicates records from the "Query_Find_Duplicates_For_Gift_Totals" query. How can I get the names of the duplicate records from the below DCount statement? DCount(" Gift_Totals.[Survey_Taker_Last_Name]", "Query_Find_Duplicates_For_Gift_Totals")

2016

How can I eliminate the Microsoft Outlook email safety message when sending an email using "SendObject" ? Attached is the image of the message.

That gave me the count. Thanks ! ! !

Yes, but how can I determine this from a query called by a form button or VBA ?

To determine which process to take. By the way, both results will be on forms.

Is it possible to retrieve the count of duplicate records (produced from the query below) ? I want to see if there are any duplicate records, if so, then show them on a form. If no duplicate records, then display a report with the single record. In (SELECT [First_Name] FROM [Location_Totals] As...

It appears that when I repaired Outlook (via "File"/"Account Settings"/"Repair") fixed the problem. Thanks for all the help given ! ! !

I have no problems receiving or sending emails. So, how can I correct this ?

I also have the below reference box checked in "Tools" . . . References . . . Microsoft Outlook 16.0 Object Library

Here ya

What does the below error mean and do I fix it ? Runtime Error 2147467259 (80004005) It fails on ==> Set M = O.CreateItem(olMailItem) ' Remember to add REFERENCE to Microsoft Outlook Object Library Dim Msg As String ' Msg = "Dear " & Firstname & ",<P> & _ ' "Your statement balance as...

I have a macro that's giving me a 3211 error. How can I find out which form, table, or query in the macro is open ?

I want to automatically advance to the next textbox after entering a numeric value.