Consulting

Results 1 to 3 of 3

Thread: Macro fails when clicking submit

  1. #1
    VBAX Regular
    Joined
    Jan 2015
    Posts
    25
    Location

    Macro fails when clicking submit

    Hi,

    I am trying to create a macro that can be activated in New Mail window.
    Clicking the button shows the macro, I can fill in the text in the different textboxes and put a checkmark in the checkboxes.
    When I click Submit that should insert the text from the form, add a subject, add a recipient etc. the macro fails..

    Run time error 91
    Object variable or With block variable not set

    When I click Debug it takes me to this line
    Do Until oFS.AtEndOfStream in the Module code

    I copied some of the code from another macro with almost the same purpose. As I am a newbie, I cannot always tell what is necessary code and which is code we build ourselves - so bear with me.

    The code is here formcode and modulecode ( I can't paste it in here - it says something about forbidden words and URL's)
    Tried to save the code in a text file to upload, but the uploader says invalid file

  2. #2
    VBAX Regular
    Joined
    Jan 2015
    Posts
    25
    Location
    So, I zip'ed the file
    Attached Files Attached Files

  3. #3
    VBAX Regular
    Joined
    Jan 2015
    Posts
    25
    Location
    Quote Originally Posted by bmdo View Post
    So, I zip'ed the file
    I solved this - how do I close the Thread?

Posting Permissions

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