[AccessD] Sending Report using Outlook object method

Mike & Doris Manning mikedorism at adelphia.net
Tue Jan 25 09:44:22 CST 2005


You can use SendObject but it won't let you add parameters...

Doris Manning
Database Administrator
Hargrove Inc.
www.hargroveinc.com


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Lonnie Johnson
Sent: Tuesday, January 25, 2005 10:31 AM
To: AccessD solving'
Subject: [AccessD] Sending Report using Outlook object method


Can I email an Access report without saving it to disk via the Outlook
object using this type of code...


    Dim appOutLook As Outlook.Application
    Dim MailOutLook As Outlook.MailItem

        Set appOutLook = CreateObject("Outlook.Application")
        Set MailOutLook = appOutLook.CreateItem(olMailItem)


Is there a property of the Outlook object to send a report that is the
database where the code resides? 



May God bless you beyond your imagination!
Lonnie Johnson
ProDev, Professional Development of MS Access Databases
Visit me at ==> http://www.prodev.us





 





		
---------------------------------
Do you Yahoo!?
 Yahoo! Search presents - Jib Jab's 'Second Term'
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





More information about the AccessD mailing list