docmd.sendobject

[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

 

[BruceM]

Do you mean you want to make it appear as if somebody else sent the e-mail?

 

[Sandy H]

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.

 

[Sandy H]

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?

 

[Sandy H]

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.

 

[BruceM]

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.