problem with email code

[dharkangel]

Hi,

I am trying to create a dynamic email message. The message will contain a summary of links and be sent to each user in a database. I cannot properly create the hyplinks inside the message. The code I've pasted below sends the email but it also displays the literal URL. so the email message looks like this:

Dear whoever,

You have the following actions due this week:

201<

http://myserver.com/folder1/folder2/dispForm.aspx?ID=201>

12<

http://myserver.com/folder1/folder2/dispForm.aspx?ID=12>

ETC.

The URL actually appears as a hyperlink but it does not go anywhere. All I am trying to do is display the list of ID's and allow the user to click on it to go to a detailed page of that ID, which is why I am trying to make this a URL

below is a snippet of my code:

EmailBody = "Dear " & UserName & "<br><br>The following actions are due this week:<br><b>QPT Actions</b><br><br>"

EmailBody = EmailBody & "<a href=

https://myserver/folder1/folder2/DispForm.aspx?ID="

& QPTRecordSet.Fields("theID") & ">" & QPTRecordSet.Fields("theID") & "</a><br>"

'SEND EMAIL
Set iMsg = CreateObject("CDO.Message")
With iMsg
Set .Configuration = iConf
.To = Email
.FROM = "admin@myserver.com"
.Subject = "Actions Due This Week: " & Date
.HTMLBody = EmailBody
.Send
End With
Set iMsg = Nothing

 

[danvlas]

1. Have you tried keeping Ctrl pressed while clicking on the hyperlink?
2. Does the browser open with any error message?
3. If you type the link in the browser does it work?




Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[mp9]

An Outlook-based email code solution that doesn't have this problem can be found at

http://www22.brinkster.com/accessory/modules/005.shtml

... but it is dependent on you using Outlook. Might be worth a look if you can't resolve this (strange) problem.

 

[dharkangel]

Thanks, but I passed on this solution in the past because of that warning message that pops up. I have to send these emails on a weekly basis and I am going to try and schedule the process if I can figure out this problem.

Thank you