Consulting

Results 1 to 11 of 11

Thread: Excel to Outlook Run Time Error 287 & Remove Default Signature

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Mentor
    Joined
    Aug 2020
    Location
    Hampshire
    Posts
    395
    Location

    Excel to Outlook Run Time Error 287 & Remove Default Signature

    I have the attached Excel macro that has a UserForm that is instigated from a command button. This allows a selection of an email recipient from a list and two TextBoxes to add extra detail. There is then the "Prepare Email" button which does exactly that and populates the relevant areas for review prior to sending. On my home setup running Office 2019 this works fine, but when at work which uses Office 2016, I get the following:-

    2021-07-07_16-42-35.jpg

    This shows up on this line :-

    2021-07-07_16-42-19.jpg

    This is part one and my main problem.

    The second part is that if a user has a default signature already setup in Outlook, then I would like this to be removed. I have been scouring online and have found mention of
    Set oBookmark = objDoc.Bookmarks("_MailAutoSig")
    but am uncertain if this is the most efficient way or if it would work in my file. Help for these two things would be very much appreciated.

    Thanks!
    Steve
    Attached Files Attached Files

Posting Permissions

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