Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Warrington, Cheshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Welcome back!
    I am using a DoCmd.SendObject command to send an email; the code fills in a Bcc list and the subject line if the user has supplied one or, if not, leaves the subject line blank.

    The user has noticed that the resultant email cannot be minimised. The Maximise box works, as does the Close box, but although the Minimise button is present, it does nothing.

    The user is asking two things.
    1. Can the minimise box be made to work?
    2. Her email signature is not inserted (as it is when she sends a normal email) so can her signature be included?
    (I've suggested using the signature icon on the Standard toolbar menu as a work round, but she wants it included automatically as it is when sending a normal email from Outlook)

    Thanks
    Silverback
    Silverback

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    > 1. Can the minimise box be made to work?

    No, the user has to either send the message or discard it before being able to return to Access.


    > 2. Her email signature is not inserted (as it is when she sends a normal email) so can her signature be included?

    No, the process that creates the message operates at a very basic level: the message will always be plain text, and default formatting, signature etc. are not added.

  3. #3
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    To get the functionality you want you will need to use VBA to create the email,
    rather than the simple docmd.sendobject method.

    You can find an example here

    If you use variations of this example you would need to set a reference to Outlook,
    under Tools References in the VBE.

    http://support.microsoft.com/kb/161088
    Andrew

  4. #4
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Warrington, Cheshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thank you, Andrew and Hans
    User has accepted work rounds of
    a: resizing/moving the window on the rare occasions when she wants to see something under the email
    b: inserting her signature using the signature button on the toolbar.

    Phew - close call there; Automation looked really heavy!
    Thanks for your help
    Silverback
    Silverback

  5. #5
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    I came across this post while looking into the same question.

    I use a mixture of Automation and SendObject in various places, depending on whether I want an attachment. I try to support users who don't use Outlook as the default mail program.
    On my computer I use Thunderbird as my default mail program.

    For me messages created with Docmd.SendObject do get my default signature, and messages created with Automation don't.
    This is the exact opposite of what is said above.

    When I look into the question of Outlook and Automation I find a range of answers:
    • Outlook signatures happen automatically - not for me they don't.
    • You need to use Outlook Object Inspectors - this seems to be a way of programmatically using the Insert Signature button in Outlook. I have never tried to use Object Inspectors before, and they did not work for me.
    • Find the file that holds the signature, open it, then write the contents of that file into the email. The location of this file varies depending on the version of Office and the version of Windows, so I was not attracted to the complications of this.
    I think I will resort to Silverback's workaround - tell users to click the Signature button - but I am wondering if anyone out there does get signatures inserted automatically into Outlook.
    Regards
    John



Posting Permissions

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