I have a command button that opens Outlook (and contains my signature...wohooo!!!).
Private Sub Command2_Click()
Dim objOutlook As Object
Dim objItem As Object
Set objOutlook = CreateObject("Outlook.Application")
Set objItem = objOutlook.CreateItem(olMailItem)
With objItem
.Subject = Title
End With
objItem.Display
End Sub
I want to attach a Query called "New Process" to the email along with a subject and body text.
Would sombody be so kind as to illustrate how best to do this in Access 2010.
Much obliged
Private Sub Command2_Click()
Dim objOutlook As Object
Dim objItem As Object
Set objOutlook = CreateObject("Outlook.Application")
Set objItem = objOutlook.CreateItem(olMailItem)
With objItem
.Subject = Title
End With
objItem.Display
End Sub
I want to attach a Query called "New Process" to the email along with a subject and body text.
Would sombody be so kind as to illustrate how best to do this in Access 2010.
Much obliged