none
send email in background

    Question

  • Access2010:

    With SendObject I am able to launch default email application with pre defined title, To, cc, text as part of the opening arguments.

    but that launches the email application and opens that window on the user's PC.  Is there a technique to send an email without launching that application?

    Thursday, February 28, 2013 12:23 PM

Answers

All replies

  • In theory, Help File says that EditMessage argument set to False should do this. But it doesn't work for Lotus Notes, for example.

    Via COM Automation of your e-mail client you can do anything you want (almost). If it is Outlook, there are billions of examples in MSDN Library. If it is Lotus Notes, there are a couple of topics on this forum, I can give some hints as well. Otherwise, googling will do the trick, I think.


    Andrey V Artemyev | Saint-Petersburg, Russia
    Russian blog artemyev.biztoolbox.ru

    Thursday, February 28, 2013 12:34 PM
  • From your suggestion - I did try the argument set to False - it did not launch the email app - and yet for reasons that aren't clear to me Windows Live Mail still showed a message that it was sending an email......and then still another message flashed that the email send failed....which was odd.....

    don't expect you to resolve that....

    when one lets the email app launch and manually send it - it sends fine...so not sure why the false setting caused it not to send ok....strange....   so it almost worked......

    Thursday, February 28, 2013 1:21 PM
  • You'd have to switch e-mail techniques and use CDO, WinSock, ...  Tony Toews covers the various options available, see:http://www.granite.ab.ca/access/email.htm

    A long time ago, I used VBA to interact with a little program called BLAT to send e-mails seamlessly.


    Daniel Pineault, 2010-2012 Microsoft MVP
    http://www.cardaconsultants.com
    MS Access Tips and Code Samples: http://www.devhut.net

    Thursday, February 28, 2013 1:29 PM
  • Windows Live Mail

    Have never used it, thus can't comment anything on this behaviour. But I'm not surprised, as I said, some clients just ignore this argument.

    Andrey V Artemyev | Saint-Petersburg, Russia
    Russian blog artemyev.biztoolbox.ru

    Thursday, February 28, 2013 1:47 PM
  • Hi msdnPublicIdentity,

    Perhaps you may try to use FindWindow to get the app, and close it via VBA. But I am not sure whether there is a way to hide the app in the background.

    You may check this link as well:

    vba script for Windows Live

    Good day.


    Yoyo Jiang[MSFT]
    MSDN Community Support | Feedback to us
    Develop and promote your apps in Windows Store
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Friday, March 01, 2013 6:42 AM