Hyperlink in email

[normadrei]

Hallo,

I am using an Access database to store my addresses and Outlook as email program. Is it possible to include a functional hyperlink into the body of an email-message (format = text)? If so - how do I do it?

A workaround could be to create e new form in Outlook which already contains the hyperlink. To send an email from access I am using “DoCmd.SendObject”. Is it possible to specify the Outlook-form to use?

Thanks for any help – normadrei

OfficeXP Develp (2002) – WinXP Prof

 

[Adrianna]

I don't know if you're trying to send an internet link of an e-mail adress link, but it would be really helpful ito know details.

If you type "Mailto:" before an e-mail address, Outlook (I'm currently on XP) will convert it into a hyperlink. I tried omitting the "mailto:" and it did not recognize it that e-mail address.

I just tried a regular www hyperlink as well and it seems to convert just fine.

So, I don't know where your trying to insert the hyperlink of if you're trying to embed it into some other fields, but if yo need additional help, ask away.

Private Sub SendEmail_Click()
DoCmd.SendObject acSendNoObject, , , Me.E_mail_Address, , , "Testing", Me.BodyofMessage, EditMessage = False
End Sub

 

[normadrei]

Hyperlink problem

Hallo Adrianna,

thanks a lot for your help. I am using OfficeXP 2002. I want to insert the hyperlink into the body of an email message. Meanwhile I was told that this only works if I start Outlook first instead of using DoCmd.SendObject:

Dim objOutlook As New Outlook.Application
Dim objOutlookMsg As Outlook.MailItem
Dim myAttachments As Outlook.Attachments
Dim objOutlookactive As Boolean

I did not yet have the chance to try it. But it seems to be a workable solution. I'll come back if it does not work.

Thanks for your help - have a nice day.
With greetings from Germany normadrei