Starting e-mail from within Access

[CD Tom]

My programs master file has the customers e-mail address, I have set it up so
if the user double clicks the e-mail address it starts outlook and I can send
that user an e-mail. Is there a way to be able to have different e-mails
provider start? Some users use yahoo,gmail or some other provider. The
program I've written has a setup section that I could have the user enter
there e-mail provider but how would I get the program to use it. Thanks for
any help.

 

[Arvin Meyer [MVP]]

Although you can use pop protocol for email with Outlook or other email
clients, I don't think you can with Yahoo, so what you need is to use the
http protocol to open a web page. With GMail that's:

https://www.google.com/accounts/Ser...&bsv=1k96igf4806cy&ltmpl=default&ltmplcache=2

and Yahoo, it's:

https://login.yahoo.com/

You will not be able to place text in a new email without logging in first.

So the answer to your question is: Only through a real email client can you
use an email function easily.

 

[CD Tom]

Thanks for the answer, will I be able to pass the e-mail address on to the
provider like I do in outlook?

 

[CD Tom]

Funny thing when I run the gmail link from explorer it comes up fine but when
I run it from within Access it gives me a message "The path '2' does not
exist or is not a directory." don't know where to go from here. Thanks for
any more help you can give me.

 

[Pete D.]

Could simplify with mailto: hyperlink. It has some quirks also but it is an
option.

 

[CD Tom]

Pete, thanks for the reply, seeing I'm not to clear on this aspect of Access
could you explain or show me how to use the mailto: hyperlink as I'm unclear
about it. Thanks

 

[Pete D.]

Mailto: is a feature of a hyperlink. Others are File:, HTTP:, FTP: etc.
A hyperlink such as mailto:[email protected] will open up the default
email program or the internet explorer if no default email client found.
mailto:[email protected]?subject=Mail from Someone
this will add the subject to the email. Access supports, depending on
version, hyperlinks in tables and texbox formats. You can also use the
FollowHyperlink method in VBA. To test and or practice try some of the
samples on the below link. It really depends on your needs if this will
work for you. I live in a sheltered environment and know that everyone that
uses my database will have Outlook so I use VBA which gives me very good
control but sometimes keeping it simple with just a hyperlink works also.
Good Luck. Pete


http://www.outfront.net/tutorials_02/adv_tech/mailto.htm

 

[Arvin Meyer [MVP]]

The problem with that approach is that the default e-mail program is almost
never a web application, and AFAIK it is impossible to remove the default
e-mail client. So while it is easy to start the default client and fill in
almost anything, it doesn't work to open a web pages and fill it much. It
may be possible with apps like roboform, which will fill in things on web
pages, but that is another outside program.

 

[CD Tom]

Thanks guys I'll work on both options and see which one works best for my
application. I always get the best help and advise from this discussion
group. Thanks again.