Agreed with ranman, do your really need to use sendkeys?
Wouldn't something like this be cleaner?
Code:
Sub sendOutlookEmail()
Dim oApp As Outlook.Application
Dim oMail As MailItem
Set oApp = CreateObject("Outlook.application")
Set oMail = oApp.CreateItem(olMailItem)
oMail.Body = "Body of the email"
oMail.Subject = "Test Subject"
oMail.To = "Someone@somewhere.com"
oMail.Display 'show the email
'oMail.Send 'or just send the email
Set oMail = Nothing
Set oApp = Nothing
End Sub
To get the outlook objects from your access project you'll need to go to your vba editor window, go to Tools menu -> References -> and then check Microsoft Outlook 16.0 Object Library (16.0 for me, maybe another version for you)
https://stackoverflow.com/questions/...hrough-outlook