 |
|
| Computers Forum Index » Computer - Databases - MS Access » Docmd.SendObject and Outlook... |
|
Page 1 of 1 |
|
| Author |
Message |
| bobh... |
 Posted: Wed Oct 21, 2009 1:38 pm |
|
|
|
Guest
|
HI All,
My company is switching from Groupwise to Outlook 2007 and so I need
to change/test all my applications that have email functionality using
Groupwise. In my testing to date I have an issue with
Docmd.Sendobject.
with Groupwise the Docmd.Sendobject would send the email right away
whether or not Groupwise was open as an example;
DoCmd.SendObject acSendNoObject, , , "bobh at (no spam) company.com", , , "DoCmd
test", "Testing", False
the above would send the email reguardless of the state of Groupwise
(opened or closed)
with Outlook the Docmd.Sendobject, if Outlook is closed the email will
be placed in Outlook's 'outbox' and will not send until Outlook is
opened by the user using the same Docmd line as above
Is there a way to get Outlook to send the email right away as
Groupwise does???
thanks
bobh. |
|
|
| Back to top |
|
|
|
| James A. Fortune... |
| Posted: Wed Oct 21, 2009 2:24 pm |
|
|
|
Guest
|
On Oct 21, 9:38 am, bobh <vulca... at (no spam) yahoo.com> wrote:
Quote: HI All,
My company is switching from Groupwise to Outlook 2007 and so I need
to change/test all my applications that have email functionality using
Groupwise. In my testing to date I have an issue with
Docmd.Sendobject.
with Groupwise the Docmd.Sendobject would send the email right away
whether or not Groupwise was open as an example;
DoCmd.SendObject acSendNoObject, , , "b... at (no spam) company.com", , , "DoCmd
test", "Testing", False
the above would send the email reguardless of the state of Groupwise
(opened or closed)
with Outlook the Docmd.Sendobject, if Outlook is closed the email will
be placed in Outlook's 'outbox' and will not send until Outlook is
opened by the user using the same Docmd line as above
Is there a way to get Outlook to send the email right away as
Groupwise does???
thanks
bobh.
Maybe:
http://groups.google.com/group/comp.databases.ms-access/msg/ef6dd24d00681a6d
James A. Fortune
CDMAPoster at (no spam) FortuneJames.com |
|
|
| Back to top |
|
|
|
| The Frog... |
| Posted: Wed Oct 21, 2009 3:32 pm |
|
|
|
Guest
|
Outlook via automation will raise the 'security alarm' each time you
try to do this. There is supposed to be a library that you can use to
replace the outlook automation objects, and it will eliminate the
security problems as well as support the same object model you work
with. Sorry, but I cannot remember the name of it. You should be able
to find it in one of the groups related to outlook. Maybe it is called
'Redemption' or something similar?
You could also try and use CDO to send the email. Just a thought.
The Frog |
|
|
| Back to top |
|
|
|
| paii, Ron... |
| Posted: Wed Oct 21, 2009 7:57 pm |
|
|
|
Guest
|
"bobh" <vulcaned at (no spam) yahoo.com> wrote in message
news:67e6dca1-4b65-4a89-8f7f-06b28778391c at (no spam) p36g2000vbn.googlegroups.com...
Quote: HI All,
My company is switching from Groupwise to Outlook 2007 and so I need
to change/test all my applications that have email functionality using
Groupwise. In my testing to date I have an issue with
Docmd.Sendobject.
with Groupwise the Docmd.Sendobject would send the email right away
whether or not Groupwise was open as an example;
DoCmd.SendObject acSendNoObject, , , "bobh at (no spam) company.com", , , "DoCmd
test", "Testing", False
the above would send the email reguardless of the state of Groupwise
(opened or closed)
with Outlook the Docmd.Sendobject, if Outlook is closed the email will
be placed in Outlook's 'outbox' and will not send until Outlook is
opened by the user using the same Docmd line as above
Is there a way to get Outlook to send the email right away as
Groupwise does???
thanks
bobh.
The function I post to your previous question will send if the intSend
parameter is set to True. As "The Frog" noted, you will get a security
warning from Outlook. |
|
|
| Back to top |
|
|
|
| paii, Ron... |
| Posted: Wed Oct 21, 2009 9:57 pm |
|
|
|
Guest
|
"paii, Ron" <none at (no spam) no.com> wrote in message
news:hbnb1n$3ne$1 at (no spam) news.eternal-september.org...
Quote:
"bobh" <vulcaned at (no spam) yahoo.com> wrote in message
news:67e6dca1-4b65-4a89-8f7f-06b28778391c at (no spam) p36g2000vbn.googlegroups.com...
HI All,
My company is switching from Groupwise to Outlook 2007 and so I need
to change/test all my applications that have email functionality using
Groupwise. In my testing to date I have an issue with
Docmd.Sendobject.
with Groupwise the Docmd.Sendobject would send the email right away
whether or not Groupwise was open as an example;
DoCmd.SendObject acSendNoObject, , , "bobh at (no spam) company.com", , , "DoCmd
test", "Testing", False
the above would send the email reguardless of the state of Groupwise
(opened or closed)
with Outlook the Docmd.Sendobject, if Outlook is closed the email will
be placed in Outlook's 'outbox' and will not send until Outlook is
opened by the user using the same Docmd line as above
Is there a way to get Outlook to send the email right away as
Groupwise does???
thanks
bobh.
The function I post to your previous question will send if the intSend
parameter is set to True. As "The Frog" noted, you will get a security
warning from Outlook.
I don't run into the security issue with Outlook because all our Emails are
initiated by the user who need to review the message before sending. I
vaguely remember that Outlook 2000 did NOT have this security setting. Use
an older version on workstation setup to automatically send emails. The
security is to protect Outlook from viruses using your address list to send
bulk emails. |
|
|
| Back to top |
|
|
|
| Lou O... |
| Posted: Fri Oct 23, 2009 1:51 am |
|
|
|
Guest
|
On Oct 21, 9:38 am, bobh <vulca... at (no spam) yahoo.com> wrote:
Quote: HI All,
My company is switching from Groupwise to Outlook 2007 and so I need
to change/test all my applications that have email functionality using
Groupwise. In my testing to date I have an issue with
Docmd.Sendobject.
with Groupwise the Docmd.Sendobject would send the email right away
whether or not Groupwise was open as an example;
DoCmd.SendObject acSendNoObject, , , "b... at (no spam) company.com", , , "DoCmd
test", "Testing", False
the above would send the email reguardless of the state of Groupwise
(opened or closed)
with Outlook the Docmd.Sendobject, if Outlook is closed the email will
be placed in Outlook's 'outbox' and will not send until Outlook is
opened by the user using the same Docmd line as above
Is there a way to get Outlook to send the email right away as
Groupwise does???
thanks
bobh.
I use Outlook Express for Sendobject operations.
It works great but Outlook Express needs to be the default mail
handler.
Outlook Express shipped with WinXP. Not sure about Vista or Win7. |
|
|
| Back to top |
|
|
|
|
|
All times are GMT
The time now is Tue Mar 16, 2010 12:56 pm
|
|