[AccessD] Sending Report using Outlook object method

DWUTKA at marlow.com DWUTKA at marlow.com
Tue Jan 25 12:14:07 CST 2005


Give them an option to 'see' the window then. Set it up as an AutoKey
function, and just have the code check for certain users that need the
ability.

Drew

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


It could have something to do with the menu's not being available. Another
guy was telling me he was having problems sending menu commands when the
Access window was hidden. It works when I open it without the window being
hidden.
 
It's strange to me too.

DWUTKA at marlow.com wrote:
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 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
-- 
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! Mail - now with 250MB free storage. Learn more.
-- 
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