docmd.sendobject

  • Thread starter Thread starter Sandy H
  • Start date Start date
S

Sandy H

Hi
I am using docmd.sendobject to send an email via a button click. Just
wondering if anyone knows if I can set a 'from' email address with this
method. I suspect the answer is no and if that's the case, what's the best
way to perform the same action while specifying a 'from' account.

Thanks
Sandy
 
My client doesn't want his staff member's email to appear as the sender. He
wants the generic office email address to appear. I thought I had done this
before somehow but can't remember how. Maybe I just need to code it up in a
module and use the SentOnBehalfOf property instead.
 
I have coded it up using a SendMessage sub and it works the way I want to
but I keep getting a message saying that a 'program is trying to access your
outlook contacts'. This is a pain because it happens once for each setting
(recipient, cc, bcc). Is there any way around this?
 
Ok, I have decided that the best way to do this without all the warnings is
to stick with docmd.sendobject and add a footnote with the reply address.
Thanks for reading my post anyway, Bruce.
 
I believe the reply address in the default e-mail program is the one used by
Access. I have poked around in some newsgroup postings, from which I
learned it may be possible to do what you want, but the specifics would
depend on your e-mail program. In any case it is not simple, and from what
I have read it can be a bit touchy if, for instance, you have multiple
e-mail profiles in Outlook. From what I can tell command line switches can
be used to open Outlook to a specific profile, but I don't know if it is
necessary first to close any other profiles, or if you can open a second
instance of Access, or really any of the details of how that would work.
 
Back
Top