• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 706
  • Last Modified:

DoCmd.SendObject acSendNoObject

Hi,

I am running the following code on two seperate systems. One works the other errors constantly;

If Not IsNull(Me.HD_Email) Then
    strMsg = MsgBox("Do You Want To Send This Customer An Email?", vbYesNo, ConTitle)
        If strMsg = vbNo Then Exit Sub
   
        DoCmd.SendObject acSendNoObject, , , Me.HD_Email, , , "At Home In London"

        Exit Sub
Else
    MsgBox "No Email Address Found For This Customer", vbOKOnly, ConTitle
    Exit Sub
End If

-----------
Using Access 2002. the error message as follows

(From)Microsoft Exchange
The Object Could Not Be Found

Followed by error from Access.
2993
Can't send this message

would appreciate any help

Scott
0
scottsanpedro
Asked:
scottsanpedro
  • 3
  • 2
1 Solution
 
dannywarehamCommented:
0
 
scottsanpedroAuthor Commented:
yep...i've been everywhere :)
0
 
dannywarehamCommented:
Okey doke

What are you trying to do - just send an email without an attachment through Outlook?
0
 
dannywarehamCommented:
If so, it may be better to do it through a different code:

'* Set a reference to 'Microsoft Outlook 9.0 Object Library  *
'* (or any other version)                                    *
'* Menu 'Tools', 'References', check the appropriate library *
'*************************************************************
Private Sub Knop1_Click()
Dim ol As New Outlook.Application
Dim olMail As Outlook.MailItem
Dim strTO As String
Dim strCC As String

   strTO = "Who@where.com"
   'strCC = "who@domain.com" & ";" & "who2@domain.com"


    Set olMail = ol.CreateItem(olMailItem)

    With olMail
        .To = strTO
        '.CC = strCC
        '.BCC = "address2@aa.com"
        '.Attachments.Add "c:\somefile.txt"
        '.Attachments.Add "c:\somefile2.txt"
        .Subject = "Testing"
        .Body = "This is the body..."
        .Display
        '.Send
    End With

    Set olMail = Nothing
    Set ol = Nothing

End Sub

I've ' out some of the code, so that you can add or remove it as nessessary
0
 
scottsanpedroAuthor Commented:
Thanks Danny...looks like it could work

I will check later as away for a bit...thank you and will get back

0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now