Senin, 30 November 2015

[MS_AccessPros] Sending email from Access

 

Hello all,


I would like for my email message being sent from Access to not go directly to the outbox. I have never had this issue before. My code below that I am using will send an email but will not let the user edit it without opening it from the outbox. I took out the email address for privacy reasons. Is there something I am missing?


Thank You

Jim Wagner


Set objol = New Outlook.Application
Set objmail = objol.CreateItem(olMailItem)
With objmail
.To = ""

.Subject = "Requesting help for the Agency/Org Database"
.Body = "Database found at P:\BUDGETING_FINANCE\FORMS AND POLICIES\Business Operations Documents" _
 & vbCrLf & vbCrLf & _
" Please assist with the following issue.... "


.NoAging = True
.Display
End With
Set objmail = Nothing
Set objol = Nothing
SendKeys "%{s}", True

__._,_.___

Posted by: luvmymelody@yahoo.com
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)

.

__,_._,___

Tidak ada komentar:

Posting Komentar