Send Object Question - Outlook Integration?

[Jeff]

Hi All

I have been going over all of the posts to find my answer and cant seem to
find anything so here goes:

I am trying to use the SendObject method to automatically send an email from
Access - everything works fine except when I try to use the "Template File"
argument:

DoCmd.SendObject acSendNoObject, , , , , , , , , "C:\Untitled.htm"

I thought this would create a new email with the "Untitled.html" as the
template for that email - am I wrong in how I am trying to use this? What I
really want to do is to generate a new email that can be modified
(EditMessage = True) but to use a template that can be selected by the user
(Right now all I am getting is a blank email - with no default signature in
it) - and if I try to add text using the "Message Text" argument it changes
my email type from "HTML" to "Plain Text".

Any assistance with this would be great.

Also is there any way after I send an email to save a copy of that email in
some format back to a table so that my users can then access the emails that
they sent to a particular client right through my access database? Or
conversely is there a way to integrate Outlook in some way to do this from
Outlook - so that when they create and send an email directly in Outlook
that I can populate a copy of that email (programmatically) directly to a
table in my access database?

If you need any more details on any of this please let me know.

Thanks to all in advance for your help,

Jeff

 

[Guest]

Hi Jeff,

You might want to look at Fairlogic's Worldcast, which is free for
non-commercial use:

http://www.fairlogic.com/worldcast/

Another alternative is FMS's Total Access Emailer:
http://www.fmsinc.com/products/Emailer/index.asp


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Jeff]

Hi Jeff,

You might want to look at Fairlogic's Worldcast, which is free for
non-commercial use:

http://www.fairlogic.com/worldcast/

Another alternative is FMS's Total Access Emailer:
http://www.fmsinc.com/products/Emailer/index.asp


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________