Access MVP (2010-2015)

oOo.oOo.oOo.oOo.oOo.oOo

Send eMail with Default (Outlook) Signature…

Question: How do I send eMail and include my Outlook signature?

Answer: Create a Module, name it anything you like except the name of the Function.

At the top of your Module under…

Option Compare Database Option Explicit

…place

Function streMailWithOutlookSignature() ‘Works in Office 2000-2016 Dim OutApp As Object Dim OutMail As Object Dim strbody […]

 701 total views

eMailing specific Reports to specific Recipients…

Question: Can anyone tell me how to eMail a report with content based data based on the individual?

Answer: Create a Module, name it anything you like except the name of the Function.

At the top of your Module under…

Option Compare Database Option Explicit

…place

Public olApp As Object Public olNameSpace As Object Public […]

 782 total views