Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2008

    Unanswered: SendObject, Outlook NON-modal?


    I'm using the SendObject command to partially create an email. It works great, but the idea is for the user to be able to cut and paste into the email from other sources. For some reason, the Outlook email opens as a modal window. Is there a way to open a normal, non-modal window instead?
    I'm using Access 2003.


  2. #2
    Join Date
    Dec 2002
    Préverenges, Switzerland
    post the sendobject code line you are using.
    i use outlook directly rather than sendobject, but help tells me:
    expression.SendObject(ObjectType, ObjectName, OutputFormat, To, Cc, Bcc, Subject, MessageText, EditMessage, TemplateFile)
    EditMessage Optional Variant. Use True (–1) to open the electronic mail application immediately with the message loaded, so the message can be edited. Use False (0) to send the message without editing it. If you leave this argument blank, the default (True) is assumed.

    currently using SS 2008R2

  3. #3
    Join Date
    Jun 2008
    Thanks for your reply. Let me clarify...the email is opening and I'm able to edit it. But since the email is modal, I can't access any other windows in order to cut and paste into the email. I have to save it as a draft.
    I'll try OLE to Outlook as a workaround.

  4. #4
    Join Date
    Nov 2007
    Adelaide, South Australia
    At that point, can't you just end the code, returning control of the application to the user?
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!

    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  5. #5
    Join Date
    Jun 2008
    Well, they want me to save the completed message after they send it, so I need to keep it open until they've finished their editing. Interesting, though. I may need to see if ending the code makes it non-modal...just out of curiosity
    I think that using OLE will fix my problem, I just don't get why a new message opended from Outlook is non-modal, but a new message created via VBA with SendObject is modal. (I'll add it to the list of questions I have for Bill Gates when I meet him!)
    Thanks anyway!

Posting Permissions

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