Email clients in database?

[Shannon R]

Hello there. I am looking to find out if it's possible to
email a client(s) directly from a database without have to
cut/paste email addresses directly into Outlook, etc. I
havben't seen anything about this in books I've read. I
must be missing something. Thanks! Please email with a
reply as I won't be able to access this board over the
holidays. Any help is appreciated!

Shannon Ralph
(e-mail address removed)

 

[Cheryl Fischer]

Shannon,

It is possible. One way to do it is:

Create a TextBox on a form which is bound to a field in your table (which is
a Text type field - not a Hyperlink) containing an email address. If you
like, you can make the ForeColor of the textbox blue and underlined, so that
it looks like a link. Then, in the DoubleClick event of the TextBox on the
form or in the Click event of a Command Button on your form, you can insert
the following VBA code:

Dim strEmail as String

strEmail = "mailto:" & Me.MyEmailField
Application.FollowHyperlink Address:=strEmail

I think this is the simplest way to send a single email to an email address
on a form. You might also want to look into the SendObject method or
Outlook Automation.

As to sending a response via private email, that would defeat the purpose of
this forum, which is that a response to your question may benefit someone
else with the same interest.

 

[Tony Toews]

Hello there. I am looking to find out if it's possible to
email a client(s) directly from a database without have to
cut/paste email addresses directly into Outlook, etc. I
havben't seen anything about this in books I've read. I
must be missing something.

There are also other solutions at the Access Email FAQ at my website.

Tony
--
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