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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

hyperlink execution with checkboxes and a button

Status
Not open for further replies.

jahlmer

Technical User
Aug 23, 2000
143
US
I have some email addresses in a table called Contacts (field1). If field2 value is set to 1 (yes), and on a form a button to take a couple other values to build a hyperlink (mailto:1@1.com&subject=something&body=something else) and execute it. Of course, this hyperlink would open outlook, and if there were a way to keystroke macro a ALT-S it would be sent and then return focus to access (97 by the way).

Upon sending the message, field3 should be populated with now() and that is the record of a followup.

Is there a keystroke macro type ability in access 97?

How would I build the hyperlink based on value1 (subject) and value2 (body) on form1?

Thanks to whomever understood this




 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top