I've probably exceeded my questions for the week, and maybe my brain is just fried (thank goodness its Friday!)....
I have the attached code which sends an email from my database via Outlook. Where/how do I go about attaching two reports from my database to the email as pdf files?
-------
Set appOutLook = CreateObject("Outlook.Application")
Set MailOutLook = appOutLook.CreateItem(olMailItem)
With MailOutLook
.to = [text386l]
.Subject = "New Position Information"
.cc = [Text388]
.HTMLBody = "<HTML><BODY><font face=Calibri>Good Afternoon Dr. " & [Text412] & ","
.HTMLBody = .HTMLBody & "<BR><BR><b>-Employee: </b>" & [PhysicianHired]
.HTMLBody = .HTMLBody & "<BR><b>-Department: </b>" & [Division]
.HTMLBody = .HTMLBody & "<BR><b>-Manager: </b>" & [Text343]
.HTMLBody = .HTMLBody & "<BR><b>-Proposed Start Date: </b>”
.HTMLBody = .HTMLBody & "<HTML><BODY><font face=Calibri><BR><BR>" & [Text416]
.Display
End With
I have the attached code which sends an email from my database via Outlook. Where/how do I go about attaching two reports from my database to the email as pdf files?
-------
Set appOutLook = CreateObject("Outlook.Application")
Set MailOutLook = appOutLook.CreateItem(olMailItem)
With MailOutLook
.to = [text386l]
.Subject = "New Position Information"
.cc = [Text388]
.HTMLBody = "<HTML><BODY><font face=Calibri>Good Afternoon Dr. " & [Text412] & ","
.HTMLBody = .HTMLBody & "<BR><BR><b>-Employee: </b>" & [PhysicianHired]
.HTMLBody = .HTMLBody & "<BR><b>-Department: </b>" & [Division]
.HTMLBody = .HTMLBody & "<BR><b>-Manager: </b>" & [Text343]
.HTMLBody = .HTMLBody & "<BR><b>-Proposed Start Date: </b>”
.HTMLBody = .HTMLBody & "<HTML><BODY><font face=Calibri><BR><BR>" & [Text416]
.Display
End With