B
Brian Arnold via AccessMonster.com
I have a two part issue/question. Here's my basic code for both parts:
Set xlApp = Nothing
Set ol = New Outlook.Application
Set NewMessage = ol.CreateItem(olMailItem)
With NewMessage
.Subject = "In Stock "
.Attachments.Add strPath, olByValue
.To = "brian"
.Send
End With
1) I'm attempting to insert the results of a simple query into the body of
the email.
2) I'd also like to automatically insert a shortcut to an Excel file into
the body of the email.
Any ideas?
Brian
Set xlApp = Nothing
Set ol = New Outlook.Application
Set NewMessage = ol.CreateItem(olMailItem)
With NewMessage
.Subject = "In Stock "
.Attachments.Add strPath, olByValue
.To = "brian"
.Send
End With
1) I'm attempting to insert the results of a simple query into the body of
the email.
2) I'd also like to automatically insert a shortcut to an Excel file into
the body of the email.
Any ideas?
Brian