Starting an email from MSAccess won't include default Signature

[Kathy Webster]

My outlook 2007 has a default stationary and a default signature. When I
start a new email from Outlook, the stationary and signature appears as
expected.

When I start an email through MSAccess from a command button that runs a
macro who's action is "Send Object", the default stationary is correct, but
the default signature is missing. The arguments of my "Send Object" action
are:

To: =[emailaddress]
(this copies the email address field from my access table to
the TO line of the email)
Edit Message: Yes

TIA,
Kathy

 

[Roady [MVP]]

That depends on how Access writes to the newly created document. If it
ignores any text in there already and simply overwrites it, precede it or
appends this. If Access doesn't do such a thing directly by a single
function, you can also code it yourself.
Compare; http://www.howto-outlook.com/howto/senddocasmail.htm

 

[Kathy Webster]

Sorry, but this doesn't answer my question. My MSAccess macro simply
executes the "Send Object" command, and populates the TO line with the
contents of myForm's [emailaddress] field. This is because my users may
have different default email programs on their computers. So this macro
looks to the Internet Explorer for the default email program, launches it,
and starts an email. The user then types their email message in the email
program, not in MSAccess. Other email programs are working fine, using
their default stationary and signature settings with no problem. But Outlook
2007 is losing the default signature. Again, if I open Outlook directly,
without using MSAccess, and start a new email, the signature is appearing by
default as expected.
Kathy

That depends on how Access writes to the newly created document. If it
ignores any text in there already and simply overwrites it, precede it or
appends this. If Access doesn't do such a thing directly by a single
function, you can also code it yourself.
Compare; http://www.howto-outlook.com/howto/senddocasmail.htm



-----

My outlook 2007 has a default stationary and a default signature. When I
start a new email from Outlook, the stationary and signature appears as
expected.

When I start an email through MSAccess from a command button that runs a
macro who's action is "Send Object", the default stationary is correct,
but the default signature is missing. The arguments of my "Send Object"
action are:

To: =[emailaddress]
(this copies the email address field from my access table
to the TO line of the email)
Edit Message: Yes

TIA,
Kathy

 

[Roady [MVP]]

I don't know anything about how the Send Object command works in MS Access.
If it loads Simple MAPI then it is not supported.

You might get a more definitive answer in the programmer's newsgroups of
Outlook and/or MS Access.

Sorry, but this doesn't answer my question. My MSAccess macro simply
executes the "Send Object" command, and populates the TO line with the
contents of myForm's [emailaddress] field. This is because my users may
have different default email programs on their computers. So this macro
looks to the Internet Explorer for the default email program, launches it,
and starts an email. The user then types their email message in the email
program, not in MSAccess. Other email programs are working fine, using
their default stationary and signature settings with no problem. But
Outlook 2007 is losing the default signature. Again, if I open Outlook
directly, without using MSAccess, and start a new email, the signature is
appearing by default as expected.
Kathy

That depends on how Access writes to the newly created document. If it
ignores any text in there already and simply overwrites it, precede it or
appends this. If Access doesn't do such a thing directly by a single
function, you can also code it yourself.
Compare; http://www.howto-outlook.com/howto/senddocasmail.htm



-----

My outlook 2007 has a default stationary and a default signature. When I
start a new email from Outlook, the stationary and signature appears as
expected.

When I start an email through MSAccess from a command button that runs a
macro who's action is "Send Object", the default stationary is correct,
but the default signature is missing. The arguments of my "Send Object"
action are:

To: =[emailaddress]
(this copies the email address field from my access table
to the TO line of the email)
Edit Message: Yes

TIA,
Kathy

 

[Ken Slovak - [MVP - Outlook]]

Send Object uses Simple MAPI calls.