This topic is locked

Sendmail - image filename as a hyperlink

7/13/2008 9:57:24 PM
ASPRunnerPro General questions
lefty author

Is it possible to send an image as a link/filename in an email event? Tried many different methods but cannot seem to send an image filename . The example below dict("photo_link") is setup in another table as a file/image . I created another table and called the file through a lookup and set view as text . Also tried hyperlink ; but none of them go with the email example below.

images are stored in folder which saves correctly . Just need to link to it somehow in email event.
Ideally would like to send the image ; tried several different methods to link with html template

message = message & " <img alt="""" border=""0"" src=""http://www.test.com/photos/""; & dict("photo_file") & "">"" & vbCrLf

which could not get to work either. cannot seem to concate the file and field together.
message =""

message = message & <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=8976&image=1&table=forumtopics' class='bbc_emoticon' alt=':unsure:' /> dict("photo_link") <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=8976&image=2&table=forumtopics' class='bbc_emoticon' alt=':unsure:' /> & vbCrLf <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=8976&image=3&table=forumtopics' class='bbc_emoticon' alt=':unsure:' />

message = message & dict("photo_desc") & vbCrLf <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=8976&image=4&table=forumtopics' class='bbc_emoticon' alt=':P' />

email="myemail@myemailaddress.com"

subject="Photo Submitted / Click on hyperlink below to view/print"
sendmail email, subject, message
Wanted the person recieving the email to click on the link to the image to retrieve image.

J
Jane 7/14/2008
lefty author 7/15/2008

Thanks Jane ,

Html formatting is not the problem . My problem is how to pull a file/image field name in an email event as a link . I want the email user to click on link back to image folder which stores the images that were added to the database. See above

lefty author 7/31/2008

Thanks Jane ,

Html formatting is not the problem . My problem is how to pull a file/image field name in an email event as a link . I want the email user to click on link back to image folder which stores the images that were added to the database. See above



any idea on this one
need field name sent in an email as a hyperlink to multiple documents.
eex. dict(" filed name")
send as

lefty author 8/1/2008

Thanks Jane,
Actually I tried this ; but message does not show as a hyperlink in the email. ( blacked out) Client tested on is set to recieve html email .
message = message & "http://www.test.com/photos/"; & dict("photo_file") & vbCrLf
I also tried
message = message & ""<a href=""http://www.test.com/photos/";" & dict("photo_file") & "</a>" & vbCrLf
but I get error message expected end of statement at dict(" - stop here.

J
Jane 8/1/2008

John.
don't add double quotes to the code.

If you want to send hyperlink in HTML format use following code:

message = message & "<a href=""http://www.test.com/photos/"; & dict("photo_file") & """>Image link</a>" & vbCrLf

lefty author 8/1/2008

John.

don't add double quotes to the code.

If you want to send hyperlink in HTML format use following code:


Thanks Jane ; That works!