ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Need help with 2 HTML files in the body of an email (https://www.excelbanter.com/excel-programming/377243-need-help-2-html-files-body-email.html)

Trefor

Need help with 2 HTML files in the body of an email
 
I have tried to modify some code from Ron de Bruin site, but its not working.
I just get my signature and not the main body which comes from a file
"BodyFile". Any ideas?

SigString =
Workbooks(WorkbookMain).Sheets(DCSheet(Data%)).Ran ge("Data_SignaturePath").Value

If Dir(SigString) < "" Then
Signature = GetBoiler(SigString)
Else
Signature = ""
End If

With OutMail
.To = ETo
.CC = Ecc
.BCC = EBcc
.Subject = ESubject
.HTMLBody = GetBoiler(AppPath & "\" & BodyFile) & "<br<br" &
Signature
If EAttach < "" Then .Attachments.Add EAttach
.Display
End With


--
Trefor


All times are GMT +1. The time now is 10:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com