Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

open a blank Email using fields

Status
Not open for further replies.

hrg

Programmer
Jan 8, 2009
46
US
Thank you for the help on the hyperlink. I now want (Getting greedy over here) a link to e-mail addresses as well and would like to know how to do this. If i entered an e-mail address into a field (txtemail) then i would like to be able to click on that field so the database opens a blank email ready to type and send to the e-mail address (retrieved from the field in the database).

e.g.


address :
post code :

web address :

email address:

so you click on the right of the ":" and it opens a email template ready to type and send. So basically if you ent to a sight it would say contact me. I want to incorporate that into my database.

How do i do this?
 
Easy as Pie with Docmd.Sendobject....

Redinfo = "This is a FED EX Overnight" & chr$(13) & Chr$(10)
Redinfo = Redinfo & "Please make sure it goes"

DoCmd.SendObject acSendNoObject, "", acFormatTXT, "ChrisC", , , "---------HOT ORDER-------", Redinfo, False 'false means the E-mail goes right out.
If you want to edit the e-mail first use "True" instead

We use this to notify the Super of a Overnight shipment

DougP, MCP

Visit my WEB site to see how Bar-codes can help you be more productive
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top