2. ASPRunnerPro General questions
  3. E-Mail Photos
This topic is locked

E-Mail Photos

 		3/10/2006 11:10:18 AM
ASPRunnerPro General questions
R
 rsmith718 author

Looking for help in including photos in e-mails when a new record is added.
Using an Access database with photo field listed as OLE Object and the data records shows Long Binary Data
Using the following code for the e-mail message body:
objCDOSYSMail.HTMLBody = "Opened By: " & rs("Opened By") & "

" & "Part Number: " & rs("Part Number") & "

" & "Rev: " & rs("Rev") & "

" & "Serial Number: " & rs("Serial Number") & "

" & "

" & "Comments: " & rs("Comments") & "

" & "Status: " & rs("Status")
Sergey Kornilov admin 3/13/2006

The problem here is that email component can attach files only.
Theoretically you can save binary field to temporary file (folder needs to have write permissions), attach it to email and delete temporary file after that.