Hello,
I am using Ron de Bruin's macro for creating a PDF-file from active worksheet, creating a new mail in outlook, attaching the PDF and add the company's signature, which consists of an image and contact information (as a .htm document). The problem is that the function I use to process the .htm-file cannot handle images.
Here is the function, by **** Kusleika:
What I need to find out is if there is any other functions I can use, or even another working macro for html signatures.
I am very grateful for any help!
Sincerely,
Amanda
I am using Ron de Bruin's macro for creating a PDF-file from active worksheet, creating a new mail in outlook, attaching the PDF and add the company's signature, which consists of an image and contact information (as a .htm document). The problem is that the function I use to process the .htm-file cannot handle images.
Here is the function, by **** Kusleika:
PHP:
Function GetBoiler(ByVal sFile As String) As String
'**** Kusleika
Dim fso As Object
Dim ts As Object
Set fso = CreateObject("Scripting.FileSystemObject")
Set ts = fso.GetFile(sFile).OpenAsTextStream(1, -2)
GetBoiler = ts.readall
ts.Close
End Function
What I need to find out is if there is any other functions I can use, or even another working macro for html signatures.
I am very grateful for any help!
Sincerely,
Amanda