[AccessD] Sending Report using Outlook object method

DWUTKA at marlow.com DWUTKA at marlow.com
Tue Jan 25 11:29:56 CST 2005


I don't see how sending an email and hiding the Access window would
clash....

Drew

-----Original Message-----
From: Lonnie Johnson [mailto:prodevmg at yahoo.com]
Sent: Tuesday, January 25, 2005 9:56 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Sending Report using Outlook object method


Thanks,
 
This was actual problem:
 
I am trying to send an email while running the code to hide the Access
window.
 
Option Compare Database
Option Explicit

Private Declare Function IsWindowVisible Lib "user32" (ByVal hwnd As Long)
As Long
Dim dwReturn As Long

Const SW_HIDE = 0
Const SW_SHOWNORMAL = 1
Const SW_SHOWMINIMIZED = 2
Const SW_SHOWMAXIMIZED = 3

...blah blah blah


I get a message saying "The command or action OutputTo is not available at
this time." I am using the SendObject command. 

Any clues???


Mike & Doris Manning <mikedorism at adelphia.net> wrote:
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


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



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