Starting Outlook from MSAccess

Kathy Webster · Joined: 13 Aug 2007 Posts: 13

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 an
Access
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

This way, the TO line of the email is populated by my MSAccess form (which
is all I want to happen), and the user is now left at the Outlook screen to
type the RE and message.

I posted at the microsoft.public.outlook board but they couldn't help.

TIA,
Kathy

Archived from group: microsoft>public>office>developer>outlook>vba

Sue Mosher [MVP-Outlook] · Joined: 12 Aug 2007 Posts: 656

If you want complete Outlook behaviors, you need to use Outlook objects, not Send Object. In your case, that means that you would need an Access VBA procedure, not a macro, to start an Outlook instance (CreateObject("Outlook.Application")) , create a new message with the CreateItem method, set that item's properties, and then display the message.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54

"Kathy Webster" wrote in message $0$22818$4c368faf@roadrunner.com...
> 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 an
> Access
> 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
>
> This way, the TO line of the email is populated by my MSAccess form (which
> is all I want to happen), and the user is now left at the Outlook screen to
> type the RE and message.
>
> I posted at the microsoft.public.outlook board but they couldn't help.
>
> TIA,
> Kathy
>
>

Kathy Webster · Joined: 13 Aug 2007 Posts: 13

I am able to click on an email address on a web site, for example, and that
will open outlook and use the default stationary and signature line. I won't
be able to build my Access code so specific, because my end users may be
using outlook, or may be using any other email program. Access is correctly
launching whatever email program is set as the default in Internet Explorer,
Tools, Internet Options, Programs, Email.

"Sue Mosher [MVP-Outlook]" wrote in message @TK2MSFTNGP05.phx.gbl...
If you want complete Outlook behaviors, you need to use Outlook objects, not
Send Object. In your case, that means that you would need an Access VBA
procedure, not a macro, to start an Outlook instance
(CreateObject("Outlook.Application")) , create a new message with the
CreateItem method, set that item's properties, and then display the message.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54

"Kathy Webster" wrote in message $0$22818$4c368faf@roadrunner.com...
> 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 an
> Access
> 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
>
> This way, the TO line of the email is populated by my MSAccess form (which
> is all I want to happen), and the user is now left at the Outlook screen
> to
> type the RE and message.
>
> I posted at the microsoft.public.outlook board but they couldn't help.
>
> TIA,
> Kathy
>
>

Sue Mosher [MVP-Outlook] · Joined: 12 Aug 2007 Posts: 656

There's a big difference between creating a blank message with a mailto: and filling in the body of an item with SendObject. I don't have an example,but I'm pretty sure that if you have a mailto: URL that fills in the body, it will also overwrite the signature, just like SendObject does.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54

"Kathy Webster" wrote in message $0$6521$4c368faf@roadrunner.com...
>I am able to click on an email address on a web site, for example, and that
> will open outlook and use the default stationary and signature line. I won't
> be able to build my Access code so specific, because my end users may be
> using outlook, or may be using any other email program. Access is correctly
> launching whatever email program is set as the default in Internet Explorer,
> Tools, Internet Options, Programs, Email.
>
> "Sue Mosher [MVP-Outlook]" wrote in message
> @TK2MSFTNGP05.phx.gbl...
> If you want complete Outlook behaviors, you need to use Outlook objects, not
> Send Object. In your case, that means that you would need an Access VBA
> procedure, not a macro, to start an Outlook instance
> (CreateObject("Outlook.Application")) , create a new message with the
> CreateItem method, set that item's properties, and then display the message.
>
> "Kathy Webster" wrote in message
> $0$22818$4c368faf@roadrunner.com...
>> 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 an
>> Access
>> 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
>>
>> This way, the TO line of the email is populated by my MSAccess form (which
>> is all I want to happen), and the user is now left at the Outlook screen
>> to
>> type the RE and message.
>>
>> I posted at the microsoft.public.outlook board but they couldn't help.
>>
>> TIA,
>> Kathy
>>
>>
>
>

Kathy Webster · Joined: 13 Aug 2007 Posts: 13

Actually the sample mailto: URL I have does not overwrite the signature. I
also did not have the problem with the signature getting overwritten with
prior versions of Outlook, such as Outlook 2002. How can I work around this
problem?

"Sue Mosher [MVP-Outlook]" wrote in message @TK2MSFTNGP03.phx.gbl...
There's a big difference between creating a blank message with a mailto: and
filling in the body of an item with SendObject. I don't have an example,but
I'm pretty sure that if you have a mailto: URL that fills in the body, it
will also overwrite the signature, just like SendObject does.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54

"Kathy Webster" wrote in message $0$6521$4c368faf@roadrunner.com...
>I am able to click on an email address on a web site, for example, and that
> will open outlook and use the default stationary and signature line. I
> won't
> be able to build my Access code so specific, because my end users may be
> using outlook, or may be using any other email program. Access is
> correctly
> launching whatever email program is set as the default in Internet
> Explorer,
> Tools, Internet Options, Programs, Email.
>
> "Sue Mosher [MVP-Outlook]" wrote in message
> @TK2MSFTNGP05.phx.gbl...
> If you want complete Outlook behaviors, you need to use Outlook objects,
> not
> Send Object. In your case, that means that you would need an Access VBA
> procedure, not a macro, to start an Outlook instance
> (CreateObject("Outlook.Application")) , create a new message with the
> CreateItem method, set that item's properties, and then display the
> message.
>
> "Kathy Webster" wrote in message
> $0$22818$4c368faf@roadrunner.com...
>> 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 an
>> Access
>> 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
>>
>> This way, the TO line of the email is populated by my MSAccess form
>> (which
>> is all I want to happen), and the user is now left at the Outlook screen
>> to
>> type the RE and message.
>>
>> I posted at the microsoft.public.outlook board but they couldn't help.
>>
>> TIA,
>> Kathy
>>
>>
>
>

Sue Mosher [MVP-Outlook] · Joined: 12 Aug 2007 Posts: 656

A mailto: that includes a body= parameter will overwrite the signature. It's the same effect as you're seeing -- the calling program is setting the body content by replacing, not appending or inserting. The only way to append or insert is to use Outlook objects (or CDO for Windows if you want to bypass Outlook).

I can't speak to how Outlook 2002 operated, as I no longer have it running here. (It's past its mainstream support lifetime.)

If you need to stick with SendObject because you can't know what mail program the user has, I think you'll have to give up on having signatures.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54

"Kathy Webster" wrote in message $0$6138$4c368faf@roadrunner.com...
> Actually the sample mailto: URL I have does not overwrite the signature. I
> also did not have the problem with the signature getting overwritten with
> prior versions of Outlook, such as Outlook 2002. How can I work around this
> problem?
>
> "Sue Mosher [MVP-Outlook]" wrote in message
> @TK2MSFTNGP03.phx.gbl...
> There's a big difference between creating a blank message with a mailto: and
> filling in the body of an item with SendObject. I don't have an example,but
> I'm pretty sure that if you have a mailto: URL that fills in the body, it
> will also overwrite the signature, just like SendObject does.
>
>
> "Kathy Webster" wrote in message
> $0$6521$4c368faf@roadrunner.com...
>>I am able to click on an email address on a web site, for example, and that
>> will open outlook and use the default stationary and signature line. I
>> won't
>> be able to build my Access code so specific, because my end users may be
>> using outlook, or may be using any other email program. Access is
>> correctly
>> launching whatever email program is set as the default in Internet
>> Explorer,
>> Tools, Internet Options, Programs, Email.
>>
>> "Sue Mosher [MVP-Outlook]" wrote in message
>> @TK2MSFTNGP05.phx.gbl...
>> If you want complete Outlook behaviors, you need to use Outlook objects,
>> not
>> Send Object. In your case, that means that you would need an Access VBA
>> procedure, not a macro, to start an Outlook instance
>> (CreateObject("Outlook.Application")) , create a new message with the
>> CreateItem method, set that item's properties, and then display the
>> message.
>>
>> "Kathy Webster" wrote in message
>> $0$22818$4c368faf@roadrunner.com...
>>> 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 an
>>> Access
>>> 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
>>>
>>> This way, the TO line of the email is populated by my MSAccess form
>>> (which
>>> is all I want to happen), and the user is now left at the Outlook screen
>>> to
>>> type the RE and message.
>>>
>>> I posted at the microsoft.public.outlook board but they couldn't help.
>>>
>>> TIA,
>>> Kathy
>>>
>>>
>>
>>
>
>

Kathy Webster · Joined: 13 Aug 2007 Posts: 13

That's too bad. How can I add a button to their Outlook toolbar that adds
the signature? I easily see how I can add a button that brings up the
signature CHOICES, but I want a button to directly choose a signature and
insert it.

"Sue Mosher [MVP-Outlook]" wrote in message %235D89SaIHA.4172@TK2MSFTNGP02.phx.gbl...
A mailto: that includes a body= parameter will overwrite the signature. It's
the same effect as you're seeing -- the calling program is setting the body
content by replacing, not appending or inserting. The only way to append or
insert is to use Outlook objects (or CDO for Windows if you want to bypass
Outlook).

I can't speak to how Outlook 2002 operated, as I no longer have it running
here. (It's past its mainstream support lifetime.)

If you need to stick with SendObject because you can't know what mail
program the user has, I think you'll have to give up on having signatures.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54

"Kathy Webster" wrote in message $0$6138$4c368faf@roadrunner.com...
> Actually the sample mailto: URL I have does not overwrite the signature. I
> also did not have the problem with the signature getting overwritten with
> prior versions of Outlook, such as Outlook 2002. How can I work around
> this
> problem?
>
> "Sue Mosher [MVP-Outlook]" wrote in message
> @TK2MSFTNGP03.phx.gbl...
> There's a big difference between creating a blank message with a mailto:
> and
> filling in the body of an item with SendObject. I don't have an
> example,but
> I'm pretty sure that if you have a mailto: URL that fills in the body, it
> will also overwrite the signature, just like SendObject does.
>
>
> "Kathy Webster" wrote in message
> $0$6521$4c368faf@roadrunner.com...
>>I am able to click on an email address on a web site, for example, and
>>that
>> will open outlook and use the default stationary and signature line. I
>> won't
>> be able to build my Access code so specific, because my end users may be
>> using outlook, or may be using any other email program. Access is
>> correctly
>> launching whatever email program is set as the default in Internet
>> Explorer,
>> Tools, Internet Options, Programs, Email.
>>
>> "Sue Mosher [MVP-Outlook]" wrote in message
>> @TK2MSFTNGP05.phx.gbl...
>> If you want complete Outlook behaviors, you need to use Outlook objects,
>> not
>> Send Object. In your case, that means that you would need an Access VBA
>> procedure, not a macro, to start an Outlook instance
>> (CreateObject("Outlook.Application")) , create a new message with the
>> CreateItem method, set that item's properties, and then display the
>> message.
>>
>> "Kathy Webster" wrote in message
>> $0$22818$4c368faf@roadrunner.com...
>>> 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
>>> an
>>> Access
>>> 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
>>>
>>> This way, the TO line of the email is populated by my MSAccess form
>>> (which
>>> is all I want to happen), and the user is now left at the Outlook screen
>>> to
>>> type the RE and message.
>>>
>>> I posted at the microsoft.public.outlook board but they couldn't help.
>>>
>>> TIA,
>>> Kathy
>>>
>>>
>>
>>
>
>

Sue Mosher [MVP-Outlook] · Joined: 12 Aug 2007 Posts: 656

For yourself or for other people to use? With Word as the email editor or with the built-in Outlook editor?

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54

"Kathy Webster" wrote in message $0$6127$4c368faf@roadrunner.com...
> That's too bad. How can I add a button to their Outlook toolbar that adds
> the signature? I easily see how I can add a button that brings up the
> signature CHOICES, but I want a button to directly choose a signature and
> insert it.
>
> "Sue Mosher [MVP-Outlook]" wrote in message
> %235D89SaIHA.4172@TK2MSFTNGP02.phx.gbl...
> A mailto: that includes a body= parameter will overwrite the signature. It's
> the same effect as you're seeing -- the calling program is setting the body
> content by replacing, not appending or inserting. The only way to append or
> insert is to use Outlook objects (or CDO for Windows if you want to bypass
> Outlook).
>
> I can't speak to how Outlook 2002 operated, as I no longer have it running
> here. (It's past its mainstream support lifetime.)
>
> If you need to stick with SendObject because you can't know what mail
> program the user has, I think you'll have to give up on having signatures.
>
> --
> Sue Mosher, Outlook MVP
> Author of Microsoft Outlook 2007 Programming:
> Jumpstart for Power Users and Administrators
> http://www.outlookcode.com/article.aspx?id=54
>
>
> "Kathy Webster" wrote in message
> $0$6138$4c368faf@roadrunner.com...
>> Actually the sample mailto: URL I have does not overwrite the signature. I
>> also did not have the problem with the signature getting overwritten with
>> prior versions of Outlook, such as Outlook 2002. How can I work around
>> this
>> problem?
>>
>> "Sue Mosher [MVP-Outlook]" wrote in message
>> @TK2MSFTNGP03.phx.gbl...
>> There's a big difference between creating a blank message with a mailto:
>> and
>> filling in the body of an item with SendObject. I don't have an
>> example,but
>> I'm pretty sure that if you have a mailto: URL that fills in the body, it
>> will also overwrite the signature, just like SendObject does.
>>
>>
>> "Kathy Webster" wrote in message
>> $0$6521$4c368faf@roadrunner.com...
>>>I am able to click on an email address on a web site, for example, and
>>>that
>>> will open outlook and use the default stationary and signature line. I
>>> won't
>>> be able to build my Access code so specific, because my end users may be
>>> using outlook, or may be using any other email program. Access is
>>> correctly
>>> launching whatever email program is set as the default in Internet
>>> Explorer,
>>> Tools, Internet Options, Programs, Email.
>>>
>>> "Sue Mosher [MVP-Outlook]" wrote in message
>>> @TK2MSFTNGP05.phx.gbl...
>>> If you want complete Outlook behaviors, you need to use Outlook objects,
>>> not
>>> Send Object. In your case, that means that you would need an Access VBA
>>> procedure, not a macro, to start an Outlook instance
>>> (CreateObject("Outlook.Application")) , create a new message with the
>>> CreateItem method, set that item's properties, and then display the
>>> message.
>>>
>>> "Kathy Webster" wrote in message
>>> $0$22818$4c368faf@roadrunner.com...
>>>> 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
>>>> an
>>>> Access
>>>> 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
>>>>
>>>> This way, the TO line of the email is populated by my MSAccess form
>>>> (which
>>>> is all I want to happen), and the user is now left at the Outlook screen
>>>> to
>>>> type the RE and message.

Kathy Webster · Joined: 13 Aug 2007 Posts: 13

For other people. Forget about MSAccess now. I just want to teach them how
to put this button on their own Outlook version 2007, since this is the
only version of Outlook that is presenting this problem. You probably know,
according to the help menu, Word editor is the only choice for v2007; the
built-in Outlook editor is no longer available for v2007.

"Sue Mosher [MVP-Outlook]" wrote in message @TK2MSFTNGP04.phx.gbl...
For yourself or for other people to use? With Word as the email editor or
with the built-in Outlook editor?

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54

"Kathy Webster" wrote in message $0$6127$4c368faf@roadrunner.com...
> That's too bad. How can I add a button to their Outlook toolbar that adds
> the signature? I easily see how I can add a button that brings up the
> signature CHOICES, but I want a button to directly choose a signature and
> insert it.
>
> "Sue Mosher [MVP-Outlook]" wrote in message
> %235D89SaIHA.4172@TK2MSFTNGP02.phx.gbl...
> A mailto: that includes a body= parameter will overwrite the signature.
> It's
> the same effect as you're seeing -- the calling program is setting the
> body
> content by replacing, not appending or inserting. The only way to append
> or
> insert is to use Outlook objects (or CDO for Windows if you want to bypass
> Outlook).
>
> I can't speak to how Outlook 2002 operated, as I no longer have it running
> here. (It's past its mainstream support lifetime.)
>
> If you need to stick with SendObject because you can't know what mail
> program the user has, I think you'll have to give up on having signatures.
>
> --
> Sue Mosher, Outlook MVP
> Author of Microsoft Outlook 2007 Programming:
> Jumpstart for Power Users and Administrators
> http://www.outlookcode.com/article.aspx?id=54
>
>
> "Kathy Webster" wrote in message
> $0$6138$4c368faf@roadrunner.com...
>> Actually the sample mailto: URL I have does not overwrite the signature.
>> I
>> also did not have the problem with the signature getting overwritten with
>> prior versions of Outlook, such as Outlook 2002. How can I work around
>> this
>> problem?
>>
>> "Sue Mosher [MVP-Outlook]" wrote in message
>> @TK2MSFTNGP03.phx.gbl...
>> There's a big difference between creating a blank message with a mailto:
>> and
>> filling in the body of an item with SendObject. I don't have an
>> example,but
>> I'm pretty sure that if you have a mailto: URL that fills in the body, it
>> will also overwrite the signature, just like SendObject does.
>>
>>
>> "Kathy Webster" wrote in message
>> $0$6521$4c368faf@roadrunner.com...
>>>I am able to click on an email address on a web site, for example, and
>>>that
>>> will open outlook and use the default stationary and signature line. I
>>> won't
>>> be able to build my Access code so specific, because my end users may be
>>> using outlook, or may be using any other email program. Access is
>>> correctly
>>> launching whatever email program is set as the default in Internet
>>> Explorer,
>>> Tools, Internet Options, Programs, Email.
>>>
>>> "Sue Mosher [MVP-Outlook]" wrote in message
>>> @TK2MSFTNGP05.phx.gbl...
>>> If you want complete Outlook behaviors, you need to use Outlook objects,
>>> not
>>> Send Object. In your case, that means that you would need an Access VBA
>>> procedure, not a macro, to start an Outlook instance
>>> (CreateObject("Outlook.Application")) , create a new message with the
>>> CreateItem method, set that item's properties, and then display the
>>> message.
>>>
>>> "Kathy Webster" wrote in message
>>> $0$22818$4c368faf@roadrunner.com...
>>>> 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
>>>> an
>>>> Access
>>>> 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
>>>>
>>>> This way, the TO line of the email is populated by my MSAccess form
>>>> (which
>>>> is all I want to happen), and the user is now left at the Outlook
>>>> screen
>>>> to
>>>> type the RE and message.

Kathy Webster · Joined: 13 Aug 2007 Posts: 13

Can anyone help?

"Kathy Webster" wrote in message $0$16661$4c368faf@roadrunner.com...
> For other people. I just want to teach them how to put this button on
> their own Outlook version 2007, since this is the only version of Outlook
> that is presenting this problem. You probably know, according to the help
> menu, Word editor is the only choice for v2007; the built-in Outlook
> editor is no longer available for v2007.
>
> "Sue Mosher [MVP-Outlook]" wrote in message
> @TK2MSFTNGP04.phx.gbl...
> For yourself or for other people to use? With Word as the email editor or
> with the built-in Outlook editor?
>
> --
> Sue Mosher, Outlook MVP
> Author of Microsoft Outlook 2007 Programming:
> Jumpstart for Power Users and Administrators
> http://www.outlookcode.com/article.aspx?id=54
>
>
> "Kathy Webster" wrote in message
> $0$6127$4c368faf@roadrunner.com...
>> That's too bad. How can I add a button to their Outlook toolbar that
>> adds
>> the signature? I easily see how I can add a button that brings up the
>> signature CHOICES, but I want a button to directly choose a signature and
>> insert it.
>>
>> "Sue Mosher [MVP-Outlook]" wrote in message
>> %235D89SaIHA.4172@TK2MSFTNGP02.phx.gbl...
>> A mailto: that includes a body= parameter will overwrite the signature.
>> It's
>> the same effect as you're seeing -- the calling program is setting the
>> body
>> content by replacing, not appending or inserting. The only way to append
>> or
>> insert is to use Outlook objects (or CDO for Windows if you want to
>> bypass
>> Outlook).
>>
>> I can't speak to how Outlook 2002 operated, as I no longer have it
>> running
>> here. (It's past its mainstream support lifetime.)
>>
>> If you need to stick with SendObject because you can't know what mail
>> program the user has, I think you'll have to give up on having
>> signatures.
>>
>> --
>> Sue Mosher, Outlook MVP
>> Author of Microsoft Outlook 2007 Programming:
>> Jumpstart for Power Users and Administrators
>> http://www.outlookcode.com/article.aspx?id=54
>>
>>
>> "Kathy Webster" wrote in message
>> $0$6138$4c368faf@roadrunner.com...
>>> Actually the sample mailto: URL I have does not overwrite the signature.
>>> I
>>> also did not have the problem with the signature getting overwritten
>>> with
>>> prior versions of Outlook, such as Outlook 2002. How can I work around
>>> this
>>> problem?
>>>
>>> "Sue Mosher [MVP-Outlook]" wrote in message
>>> @TK2MSFTNGP03.phx.gbl...
>>> There's a big difference between creating a blank message with a mailto:
>>> and
>>> filling in the body of an item with SendObject. I don't have an
>>> example,but
>>> I'm pretty sure that if you have a mailto: URL that fills in the body,
>>> it
>>> will also overwrite the signature, just like SendObject does.
>>>
>>>
>>> "Kathy Webster" wrote in message
>>> $0$6521$4c368faf@roadrunner.com...
>>>>I am able to click on an email address on a web site, for example, and
>>>>that
>>>> will open outlook and use the default stationary and signature line. I
>>>> won't
>>>> be able to build my Access code so specific, because my end users may
>>>> be
>>>> using outlook, or may be using any other email program. Access is
>>>> correctly
>>>> launching whatever email program is set as the default in Internet
>>>> Explorer,
>>>> Tools, Internet Options, Programs, Email.
>>>>
>>>> "Sue Mosher [MVP-Outlook]" wrote in message
>>>> @TK2MSFTNGP05.phx.gbl...
>>>> If you want complete Outlook behaviors, you need to use Outlook
>>>> objects,
>>>> not
>>>> Send Object. In your case, that means that you would need an Access VBA
>>>> procedure, not a macro, to start an Outlook instance
>>>> (CreateObject("Outlook.Application")) , create a new message with the
>>>> CreateItem method, set that item's properties, and then display the
>>>> message.
>>>>
>>>> "Kathy Webster" wrote in message
>>>> $0$22818$4c368faf@roadrunner.com...
>>>>> 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
>>>>> an
>>>>> Access
>>>>> 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
>>>>>
>>>>> This way, the TO line of the email is populated by my MSAccess form
>>>>> (which
>>>>> is all I want to happen), and the user is now left at the Outlook
>>>>> screen
>>>>> to
>>>>> type the RE and message.
>
>

Ken Slovak - [MVP - Outlo · Joined: 12 Aug 2007 Posts: 405

You can code a COM addin and customize the Ribbon for any open item
(Inspector) you want and distribute that addin to the users. Or you can
teach them how to customize the QAT, which can't be done using code. In that
case each QAT you want customized (there's one for each of the 17 possible
Outlook Inspector Ribbons) has to be customized individually.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm

"Kathy Webster" wrote in message $0$30709$4c368faf@roadrunner.com...
> Can anyone help?

Kathy Webster · Joined: 13 Aug 2007 Posts: 13

Thank you Ken. Teaching them to customize the QAT would be totally
sufficient. My question is:
I know how to add the "Signatures" button to the QAT; I would like to know
how to add a SPECIFIC sigature selection to the QAT. I don't want them to
have to choose a signature from the dropdown, since they have only created
one signature. I'd like the QAT button to directly select the one and only
signature that they have created.

"Ken Slovak - [MVP - Outlook]" wrote in message @TK2MSFTNGP06.phx.gbl...
> You can code a COM addin and customize the Ribbon for any open item
> (Inspector) you want and distribute that addin to the users. Or you can
> teach them how to customize the QAT, which can't be done using code. In
> that case each QAT you want customized (there's one for each of the 17
> possible Outlook Inspector Ribbons) has to be customized individually.
>
> --
> Ken Slovak
> [MVP - Outlook]
> http://www.slovaktech.com
> Author: Professional Programming Outlook 2007
> Reminder Manager, Extended Reminders, Attachment Options
> http://www.slovaktech.com/products.htm
>
>
> "Kathy Webster" wrote in message
> $0$30709$4c368faf@roadrunner.com...
>> Can anyone help?
>

Ken Slovak - [MVP - Outlo · Joined: 12 Aug 2007 Posts: 405

That you can't do.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm

"Kathy Webster" wrote in message $0$17365$4c368faf@roadrunner.com...
> Thank you Ken. Teaching them to customize the QAT would be totally
> sufficient. My question is:
> I know how to add the "Signatures" button to the QAT; I would like to know
> how to add a SPECIFIC sigature selection to the QAT. I don't want them to
> have to choose a signature from the dropdown, since they have only created
> one signature. I'd like the QAT button to directly select the one and only
> signature that they have created.

Kathy Webster · Joined: 13 Aug 2007 Posts: 13

Can't do? Never heard an MVP say that!

"Ken Slovak - [MVP - Outlook]" wrote in message @TK2MSFTNGP04.phx.gbl...
> That you can't do.
>
> --
> Ken Slovak
> [MVP - Outlook]
> http://www.slovaktech.com
> Author: Professional Programming Outlook 2007
> Reminder Manager, Extended Reminders, Attachment Options
> http://www.slovaktech.com/products.htm
>
>
> "Kathy Webster" wrote in message
> $0$17365$4c368faf@roadrunner.com...
>> Thank you Ken. Teaching them to customize the QAT would be totally
>> sufficient. My question is:
>> I know how to add the "Signatures" button to the QAT; I would like to
>> know how to add a SPECIFIC sigature selection to the QAT. I don't want
>> them to have to choose a signature from the dropdown, since they have
>> only created one signature. I'd like the QAT button to directly select
>> the one and only signature that they have created.
>

Ken Slovak - [MVP - Outlo · Joined: 12 Aug 2007 Posts: 405

There are lots of things you can't do with Outlook that people want. Some of
them we've figured out workarounds for, others just can't be done.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm

"Kathy Webster" wrote in message $0$1116$4c368faf@roadrunner.com...
> Can't do? Never heard an MVP say that!