Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 06-26-2003, 10:58 AM   #1
gdanalakshmi
Senior Member
 
Join Date: Nov 2002
Posts: 102
Thanks: 0
Thanked 0 Times in 0 Posts
gdanalakshmi
Hyperlink

I am trying to send an email from Access application using VBA.

I want to send a hyperlink in the body of the email. The Email goes through Lotus Notes.

How Do i implement that?? Is there any special tag for that??

gdanalakshmi is offline   Reply With Quote
Old 06-26-2003, 11:38 PM   #2
IMO
Now Known as ___
 
IMO's Avatar
 
Join Date: Sep 2002
Location: On a small Asteroid Orbiting Planet Zog, I think!!
Posts: 723
Thanks: 0
Thanked 1 Time in 1 Post
IMO is on a distinguished road
Create a text box and a button on a form, call the text box txtEmailAddress and add the following code to the onclick event of the button

Private Sub YourButton_Click()

Dim strTextMessage As String
strTextMessage = strTextMessage & "http://www.access-programmers.co.uk "
DoCmd.SendObject acSendNoObject, , , Me!txtEmailAddress, , , "Hyperlink", strTextMessage, True

End Sub

Type the email address in the text box and click the button

IMO
__________________
Now known as ___
IMO is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump




All times are GMT -8. The time now is 11:17 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World