+ Reply to Thread
Results 1 to 2 of 2

VBA: Getting signature data from signed and unsigned signature blocks

  1. #1
    Registered User
    Join Date
    09-09-2015
    Location
    Gloucestershire, England
    MS-Off Ver
    Microsoft Word 2013
    Posts
    1

    VBA: Getting signature data from signed and unsigned signature blocks

    I am using Microsoft Office 2013.

    I have a number of Excel and Word documents all of which contain a number of signature blocks.
    I want to be see which signature blocks have been signed and which ones have not been signed.
    My problem is that in the simplified VBA code below Signatures.Count only returns the number of SIGNED blocks.
    How do I get data from both signed and unsigned signature blocks.

    Sub getsigdata()

    Dim signer As String

    countsigs = ActiveDocument.Signatures.Count

    If countsigs > 0 Then
    For i = 1 To countsigs

    signer = ActiveDocument.Signatures.Item(i).Setup.SuggestedSigner
    MsgBox (signer)
    Next i

    End If

    End Sub

  2. #2
    Registered User
    Join Date
    09-20-2019
    Location
    Montreal, Canada
    MS-Off Ver
    2016 MSO (160.4639.1000) 32 bits
    Posts
    1

    Re: VBA: Getting signature data from signed and unsigned signature blocks

    You've probably found the answer by now but this is for people like me
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 04-15-2015, 09:34 PM
  2. add excel data in body email (data range is dynamic) & signature issue
    By Marijke in forum Outlook Programming / VBA / Macros
    Replies: 3
    Last Post: 11-25-2014, 05:41 AM
  3. Replies: 0
    Last Post: 04-04-2013, 07:18 AM
  4. Macro to fill in signature and date blocks
    By Hambone70 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-31-2013, 11:09 AM
  5. Multiple signature or signature areas on a form
    By dstocker in forum Excel General
    Replies: 0
    Last Post: 05-25-2012, 05:08 PM
  6. Help with Signed vs Unsigned Macros
    By swieduwi in forum Excel General
    Replies: 0
    Last Post: 04-27-2005, 09:48 AM
  7. How do I add a signature
    By Penfold in forum Excel General
    Replies: 1
    Last Post: 02-14-2005, 04:06 PM

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