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 / May 2006

Tip: Looking for answers? Try searching our database.

Interfacing with Internet Email

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
DebCMom - 12 May 2006 21:39 GMT
Need help finding solution - I have an Access db, with extensive vba coding.  
The last step in the process I'm currently working on, is to take information
that has been collected in the process, and send an email out to a stored
email address.  Simple, right?  Well, it would be, except that we currently
use a web-based email system (yahoo). Typically, the person who is using the
Access DB would already have an IE window open, signed in to the email
account.  How can I interface VBA with the IE window, so that the collected
information/email address can compose and then send the message?

I apologize if this is exceedingly simple, but have searched high and low,
and not found anything that was the obvious solution.

Thanks!
Mark A. Sam - 13 May 2006 16:48 GMT
Hello Deb,

I think the easiest thing for you to do is to create a table with the email
addresses, then iterate through the table to send your emails individually.
It would require copying the addresses from the Yahoo account to the table.
If there is a way to read the yahoo page, I don't know.

God Bless,

Mark A. Sam

> Need help finding solution - I have an Access db, with extensive vba
> coding.
[quoted text clipped - 14 lines]
>
> Thanks!
DebCMom - 25 May 2006 16:32 GMT
Thanks Mark,

I know how to get the email addresses and the information that is needed
within each email that is to be sent.  My problem is in determining how to
physically send the information to the web-base email page.  Most of the
information I've found on sending email via Access/VBA deals with sending via
outlook.  We cannot use the outlook feature for this function, it MUST
interface with the web-base email.  I was thinking that since the web email
is merely an HTML form, there has to be a way...  Any help would be greatly
appreciated.

Deb

> Hello Deb,
>
[quoted text clipped - 25 lines]
> >
> > Thanks!
 
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.