PDA

View Full Version : Hyperlink specifying

Sam Summers
03-11-2003, 10:50 AM
I am trying to insert a hyperlink in an Email so users can click on it to download the snapshot viewerif they wish.
I have this line of code which looks fine, but the link doesn't work.

DoCmd.SendObject acSendReport, stDocName, "SnapShot Format(*.snp)", , , , "Equipment Manifest", "Please find attached Equipment Manifest.If you are unable to view this attachment then please download the viewer free from the Microsoft website by clicking on this link http://download.microsoft.com/download/access2000/viewer/1/win98/EN-US/SnpVw90.exe", True


I obviously cannot be actually creating a link, only inserting the text.

Thanks for your help
Fornatian
03-11-2003, 01:24 PM
As a workaround you could always attach a linking hyperlink file
Include this code and create an empty page with only the link on.

Open "C:\htmltest.htm" For Output As #1
Dim stLink
stLink = "<html><a href=http://download.microsoft.com/download/access2000/viewer/1/win98/EN-US/SnpVw90.exe>Download Here</a></html>"
Write #1, stLink
Close #1

Actually, seeing as your filelink is static you don't need to create the file dynamically, you could just attach it as a normal attachment.

It's a workaround, I just couldn't get my head round how to get it put the link in the text.