I have this code that works fine, but Part 1 question is it pops up when OL2000 is open saying an app is trying to send on your behalf an i have to wait 30 seconds to click Yes. How can i stop that? I have used the sendObject and set true to edit which is fine, but i would like to send without any editing or 30 sec warnings.
***
Dim objOutlook As Outlook.Application
Dim objEmail As Outlook.MailItem
'**creates an instance of Outlook
Set objOutlook = CreateObject("Outlook.application"
Set objEmail = objOutlook.CreateItem(olMailItem)
With objEmail
.To = "me@myemail.com"
.Subject = strSubject
.Body = strBody
.Send
End With
(i've declared variables elsewhere, it works fine too much to copy paste)
PART 2 question is can i format the body to use any other fonts or make the font bigger in the email? The above code uses a different font than the sendObject way. Any help would be appreciated. See below for strBody declaration.
****
' Set the Body of the Internal email
strBody = "Incident Number: " & Incident & vbCrLf & _
"Other Incident: " & OtherInc & vbCrLf & vbCrLf & _
"Priority: " & Priority & vbCrLf & vbCrLf & _
"Assigned Date: " & Date & vbCrLf & _
"Target Date: " & TargetDate & vbCrLf & vbCrLf & _
"Employee: " & strEmp & vbCrLf & _
"Ext: " & strExt & vbCrLf & vbCrLf & _
"Description: " & Description & vbCrLf & _
vbCrLf & vbCrLf
****
***
Dim objOutlook As Outlook.Application
Dim objEmail As Outlook.MailItem
'**creates an instance of Outlook
Set objOutlook = CreateObject("Outlook.application"
Set objEmail = objOutlook.CreateItem(olMailItem)
With objEmail
.To = "me@myemail.com"
.Subject = strSubject
.Body = strBody
.Send
End With
(i've declared variables elsewhere, it works fine too much to copy paste)
PART 2 question is can i format the body to use any other fonts or make the font bigger in the email? The above code uses a different font than the sendObject way. Any help would be appreciated. See below for strBody declaration.
****
' Set the Body of the Internal email
strBody = "Incident Number: " & Incident & vbCrLf & _
"Other Incident: " & OtherInc & vbCrLf & vbCrLf & _
"Priority: " & Priority & vbCrLf & vbCrLf & _
"Assigned Date: " & Date & vbCrLf & _
"Target Date: " & TargetDate & vbCrLf & vbCrLf & _
"Employee: " & strEmp & vbCrLf & _
"Ext: " & strExt & vbCrLf & vbCrLf & _
"Description: " & Description & vbCrLf & _
vbCrLf & vbCrLf
****