Results 1 to 8 of 8
  1. #1
    5 Star Lounger Ruff_Hi's Avatar
    Join Date
    Feb 2001
    Location
    New York, New York, USA
    Posts
    768
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Get Signiture via VBA (Outlook XP)

    Hi All,

    I'm trying to write a small vba macro that will automatically send emails to a whole bunch of addresses. I want to reference my standard signature but I'm not sure how to using VBA - can anyone point me in the right direction.

    Thanks
    (Location Australia, then UK, but now USA. Heart, outlook, attitude, etc always Australian)
    Quote: "All Happiness is the release of internal pressure"

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Get Signiture via VBA (Outlook XP)

    AFAIK Sigs are not part of the object model, but you can either hard code the Sig into the VB code, or get to the file and import the text, or use a custom form containing the sig. See outlookcode - sigs and outlookcode - custom forms with sigs.
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    Cincinnati, Ohio, USA
    Posts
    7,089
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Get Signiture via VBA (Outlook XP)

    John, are you aware of any add-ins that will insert a random signature block? I, um, have a collection of quotes that I like to stick in my emails, and I'd like to vary them up. I have not found anything yet that will do this automagically!
    -Mark

  4. #4
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Get Signiture via VBA (Outlook XP)

    Sperry has one for US$9 you could look into.
    -John ... I float in liquid gardens
    UTC -7ąDS

  5. #5
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    Cincinnati, Ohio, USA
    Posts
    7,089
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Get Signiture via VBA (Outlook XP)

    Hey, that's good stuff...and cheap, too. Now how did I miss that in my hunt??

    Thanks John!
    -Mark

  6. #6
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Get Signiture via VBA (Outlook XP)

    Ornic and Sperry are the main places I look for that kind of stuff.
    -John ... I float in liquid gardens
    UTC -7ąDS

  7. #7
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    Cincinnati, Ohio, USA
    Posts
    7,089
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Get Signiture via VBA (Outlook XP)

    Ornic appears to have one product in multiple flavours...but then I just now started cruising through their site. Thanks again!
    -Mark

  8. #8
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Get Signiture via VBA (Outlook XP)

    On the Ornic home page alternate solution for client side takes you to their older more "specific-solution" products, those down the page a bit which start with names of "Ex..." and "Ca...".
    -John ... I float in liquid gardens
    UTC -7ąDS

Posting Permissions

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