


StrFileContent = Input(LOF(iFile), iFile) ' Assigning content of user signature file to strFilecontent (I get the signature with this but the logo does not show) CC sectionĭim icounter As Long 'counter for the column letter in "Clients Database" to fill the. Xĭim x As Long 'counter for the date contained in column B row xĭim d As Long 'counter for the row number in "Clients Database" to fill the. 'Dim signaturefile As String: signaturefile = "C:\Users\browngil\AppData\Roaming\Microsoft\Signatures\X_files\image001.png"ĭim Backupfile As String: Backupfile = "V:\Admin Factures\FACTURES X " & Year(Date) & "\Transport\Factures X Transport\"ĭim BOUCI As Range 'BOUCI.value is the invoice number i.e. 'Dim signaturefile As String: signaturefile = strFilename & "X_files\" & Dir(Environ("appdata") & "\Microsoft\Signatures\*.png") ''Using DIR function to be able to use wildcards to match the htm signature file so any user can get their own signature on the emails generatedĭim signaturefile As String: signaturefile = strFilename & Dir(Environ("appdata") & "\Microsoft\Signatures\*.htm")

Dim strFilename As String: strFilename = Environ("appdata") & "\Microsoft\Signatures\"
