attaching an email so you can view it in a form

[GirlBlonde]

hi guys

i have a question, i have actually done it and i can not for the life of me figure out how i did it a long time ago. i have a form where i want to view the relating email in a record. i have one working now as i said i just can not remember how i inserted the email into the table. i did it via inserting an OLE item in the table, but i dont remember how i linked it to view the relating email??dumb huh.

so my question is how can i view a specific email via a form. so if i want to add a record and attach the relating email?

also is it possible for you to send an email via the email field in a form? curious.

thanks

Energy & persistance conquer all things!

 

[SeeThru]

You can insert all the HTML for an email, and then use that to generate a temporary file and view it...

dim strFile Path as string
strfilepath="C:\temp\tempemail.htm"
Open strFilePath For Append As #1
Print #1, BodyHTML
Close #1

If Not fHandleFile(strFilePath, WIN_NORMAL) Then
'function to open any file - this opens in web browser
    MsgBox "There was an error opening the preview file!", vbCritical, "Email Preview"
End If

SeeThru
Synergy Connections Ltd - Telemarketing Services

http://www.synergyconnections.co.uk