Need help with 2 HTML files in the body of an email

T

Trefor

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%)).Range("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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help with 2 HTML files in the body of an email using excel co 6
Email from Excel Function 3
Questions on Ron de Bruin's Excel Email Macro 4
Get info from first cell in row. 5
The Dear x at the top is formatted as times new roman font...why?! 1
Error with signature in email - wingdings! 2
Macro to add signature - error - Wingdings! 0
add HTML signature within an HTML message 2

Top