| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Importing html documents into Excel adds rows to the body. | Excel Discussion (Misc queries) | |||
| body of email disappears when I send an email from Excel | Excel Discussion (Misc queries) | |||
| Literally displaying imported cells with and tags | Excel Discussion (Misc queries) | |||
| Loading in the BODY section of HTML from a web page | Excel Programming | |||
| Mail Worksheet as (html) message body | Excel Programming | |||
Linear Mode
