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?

Answer 1

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

Answer 2

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......

Answer 3

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

Answer 4

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

Answer 5

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.