Re: Automated email

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Geoff (geoff_at_nospam.com)
Date: 07/04/04


Date: Sun, 4 Jul 2004 02:06:11 +0100

This behaviour seems a little odd. As you probably already know, it
shouldn't be necessary to set the focus on Outlook to send an email, nor
should it matter whether Outlook is already running. Only one instance of
Outlook can run on a computer, so you should be able to create a new
instance if Outlook is not running or grab the running instance if it is
running (ie you won't be allowed to start more than one instance). Once
you've got an object variable pointing to Outlook, you should be able to
send emails from Access without setting the focus on Outlook, ie sending
emails can happen invisibly. I'm not sure how else to help. There is some
standard code available to start or grab an instance of Outlook and use it
to create and send a mail item.

(You're not quite clear whether you're sending one email or many - not that
that matters.)

Regards.
Geoff



Relevant Pages

  • RE: Retrieving information
    ... The only way to grab the info from a selected Contact is to grab the ... Your procedure stub is incorrect - it should be Sub Item_CustomPropertyChange. ... Eric Legault - Outlook MVP, MCDBA, MCTS ... Maybe even a book recommendations would be ...
    (microsoft.public.outlook.program_forms)
  • Re: Outlook
    ... It's this process of Outlook waiting for something before it is really ... If I could grab the object and then wait ... for the Outlook's MAPI signon event, it would be great, but I can't grab ... the object at this profile selection or server logon point. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Why use an Outlook Form?
    ... The code would, in fact, be quite a bit more complicated than the Excel VBA code to grab the data and put it in your master sheet. ... Sue Mosher, Outlook MVP ...
    (microsoft.public.outlook.program_forms)
  • RE: Grab info from attachment and put into SQL db
    ... The next step is to become familiar with the Outlook Object Model: ... Then basically you need to get a handle to the MailItem you want, and grab ... Excel Object Model for that scenario. ...
    (microsoft.public.outlook.program_vba)
  • Grabbing an email Address from a Form
    ... i have a contact form in a app we have. ... want to grab the email address from the form and open up Outlook, ... WITH oMailitem ...
    (microsoft.public.fox.programmer.exchange)