Email .HTMLBody code

[Mick99]

I never thought I would be needing to do this but here goes. I can create PDF's, DOCX's retaining the PDF formatting save them back to differant network locations and then retrieve and attach to emails that are genrated for differant areas, however I have been asked to scrap the attahcment and insert the content of the attachment directly into the body of the email. I have had a good browse around the net with no real approach. The code below simply gets the recepients email address adds the subject and then is looking for the .HTMLBody which simply comes through in the body as "O:\div\AKL\Resgroup\E - Reports\HTML Files\DRAFT TEST .html" '' "Please find your, Blagh" Any help would be greatly appreciated.


.To = RScoloumdetail(2) ' Gets Email Address
.CC = ""
.BCC = ""
.Subject = "TESTING - " 'Hi," & " " & RScoloumdetail(0) & " " & RScoloumdetail(1) & " " & "here is your Statement" & " ""Hi," & " " & RScoloumdetail(2)
.HTMLBody = "O:\div\AKL\Resgroup\E - Reports\HTML Files\DRAFT TEST .html" '' "Please find your, Blagh"
' .Attachments.Add FilePath ' EmailFile & FileName ' Not required
If Send = True Then


.Save
Else
.Save
End If


Cheers Mick

[InsuranceGuy]

Since HTML is just a text file, you can read the file into a variable and then pass the string variable to .HTMLBody

See: http://codevba.com/office/read_text_...g_variable.htm

Cheers,


Jeff

[Mick99]

Hi Jeff, I have been playing with this all day and have been able to get the text into the body but not with the formatting. After your help I now have the body plus the formatting. Cheers mate really appreciate it.


Cheers Mick