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 / General 2 / January 2008

Tip: Looking for answers? Try searching our database.

Emailing from Access

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Oly - 14 Jan 2008 13:45 GMT
Good Day Group,

I have an access database on WindowsXP that  creates an HTML attachment  and
addresses it from data from the database and sents it automatically to the
mail agent (Outllook) to send it through.  Using the same access database on
Vista and Windows Mail , I get an error preventing this feature.  

Does the community have any recommendation on how to fix this problem for me?
Signature

Oly

Arvin Meyer [MVP] - 14 Jan 2008 15:47 GMT
Try the following code which should work for Outlook:

http://www.datastrat.com/Code/OutlookEmail.txt

If it doesn't, you problem is with permissions, not the code, and you'll
need to deal with UAC and email permissions.
Signature

Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

> Good Day Group,
>
[quoted text clipped - 7 lines]
> Does the community have any recommendation on how to fix this problem for
> me?
Oly - 14 Jan 2008 20:52 GMT
Thank you Mr. Meyer for your reply.
I have not tested it,  but I will and I'll post my results.  But, before I
do  test, do you think this would work with Windows Mail?  Do you think I
could modify the code for Windows Mail?

Thnaks again.
Signature

Oly

> Try the following code which should work for Outlook:
>
[quoted text clipped - 13 lines]
> > Does the community have any recommendation on how to fix this problem for
> > me?
Arvin Meyer [MVP] - 15 Jan 2008 03:06 GMT
I doubt that it will work for Windows Mail. It is an Outlook solution.
SendObject is the only thing which will work with Windows Mail. You can also
use SMTP without an interface.
Signature

Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

> Thank you Mr. Meyer for your reply.
> I have not tested it,  but I will and I'll post my results.  But, before I
[quoted text clipped - 23 lines]
>> > for
>> > me?
Tony Toews [MVP] - 16 Jan 2008 04:05 GMT
>I have an access database on WindowsXP that  creates an HTML attachment  and
>addresses it from data from the database and sents it automatically to the
>mail agent (Outllook) to send it through.  Using the same access database on
>Vista and Windows Mail , I get an error preventing this feature.  

What is the exact error message?

Tony
Signature

Tony Toews, Microsoft Access MVP
  Please respond only in the newsgroups so that others can
read the entire thread of messages.
  Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
  Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 
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



©2009 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.