Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Modules / DAO / VBA / September 2005

Tip: Looking for answers? Try searching our database.

2nd Post - SendObject Question

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
MJatAflac - 20 Sep 2005 11:39 GMT
I am using the SendObject method to send an email to a "resource" letting
them know that they have just been assigned to a task. This works great but
I'm curious to know whether I can turn off the warning that pops up warning
the user that the system is trying to automatically send an email. Also, is
it possible to send the message FROM someone other than the user who is
currently signed on. I tried changing the from attribute in the sendobject
method but this seems to make no difference. I would like the mail to be sent
by an EMail ID that represents the system that's generating the message IE:
ResourceManager@aflac.com.

Any ideas?

Thanks in advance,

m

Signature

Michal Joyce
Project Management IS Analyst
Aflac - Project Management Office

Paul - 20 Sep 2005 11:52 GMT
Michal

email warning - This question has been asked before. if you type in
"warning" in the search facility there are several topics on this subject.
One subject has a link to a freeware tool which will supress the warning.

The other questiona I am unsure of.

Paul

> I am using the SendObject method to send an email to a "resource" letting
> them know that they have just been assigned to a task. This works great but
[quoted text clipped - 11 lines]
>
> m
MJatAflac - 20 Sep 2005 11:56 GMT
Thanks much Paul!
Signature

Michal Joyce
Project Management IS Analyst
Aflac - Project Management Office

> Michal
>
[quoted text clipped - 21 lines]
> >
> > m
David C. Holley - 20 Sep 2005 13:22 GMT
What exactly are you sending using SendObject? It is entirely possible
to use VBA running from within Access to create an Outlook Item
including TaskItems.

> Thanks much Paul!
Rick Brandt - 20 Sep 2005 12:28 GMT
> I am using the SendObject method to send an email to a "resource"
> letting them know that they have just been assigned to a task. This
[quoted text clipped - 8 lines]
>
> Any ideas?

The warning is coming from your version of Outlook and there is no easy way to
eliminate it except to NOT use Outlook.  In an Exchange server environment the
Exchange administrator can make changes that remove it, but you cannot do so on
the client.  There is a free utilty that will automatically detect the prompt
and answer [Yes] for you.

SendObject has no facility for changing the From argument.  Using automation to
control Outlook or CDO allow you to do this, but you would have to have
permissions to do so on the Exchange server.

Signature

I don't check the Email account attached
to this message.     Send instead to...
RBrandt    at       Hunter      dot      com

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.