Interfacing with Internet Email

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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
 
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
 
Back
Top