Results 1 to 4 of 4

outlook signature formatted

Threaded View

michel71 outlook signature formatted 10-26-2011, 08:59 AM
jaslake Re: outlook signature... 10-26-2011, 06:25 PM
Leith Ross Re: outlook signature... 10-26-2011, 07:18 PM
jaslake Re: outlook signature... 10-26-2011, 08:28 PM
  1. #1
    Registered User
    Join Date
    10-26-2011
    Location
    italy
    MS-Off Ver
    Excel 2003
    Posts
    1

    Smile outlook signature formatted

    Hi all,
    I'm used to send excel spreadsheet via outlook email, adding at the end my businees signature using the following function
    Public Function GetBoiler(ByVal sFile As String) As String
    
        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
    
    and in the routine
    ------------------
        SigString = "C:\Documents and Settings\" & Environ("username") & _
                "\Application Data\Microsoft\Signatures\professional.txt"
    
    Signature = GetBoiler(SigString)
    
    ------------------

    unfortunately in this way the signature is not formatted

    any advise to capture the signature formatted?

    thanks in advance
    Michelangelo
    Last edited by Leith Ross; 10-26-2011 at 07:12 PM. Reason: Added Code Tags

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1