SendObject Method

[JustJim]

Hi All,
I know this is not strictly an Access Problem, but hopefully some advice will be forthcoming.

When I execute

DoCmd.SendObject acSendNoObject, , acFormatRTF, strEmailAddress, , , strEmailSubject, strEmailBody, True

all is well and an email starts on my user's Outlook compose screen...

But... when the e-mail is sent, Outlook doesn't add her signature block to the email. It does add the department she works for's disclaimer!

There are no arguments left in the SendObject method, does anyone have any ideas how to tell Outlook to do what I want (which by the way, is to send an email just as if my users have clicked New in Outlook and typed it themselves)

Jim

[ADezii]

Hi All,
I know this is not strictly an Access Problem, but hopefully some advice will be forthcoming.

When I execute

DoCmd.SendObject acSendNoObject, , acFormatRTF, strEmailAddress, , , strEmailSubject, strEmailBody, True

all is well and an email starts on my user's Outlook compose screen...

But... when the e-mail is sent, Outlook doesn't add her signature block to the email. It does add the department she works for's disclaimer!

There are no arguments left in the SendObject method, does anyone have any ideas how to tell Outlook to do what I want (which by the way, is to send an email just as if my users have clicked New in Outlook and typed it themselves)

Jim

Within Outlook, do you have the Add signatures to all outgoing messages check box selected? (Tools, Options, Signature Tab).

[JustJim]

Within Outlook, do you have the Add signatures to all outgoing messages check box selected? (Tools, Options, Signature Tab).

In Outlook 2003 SP2 there ain't a Signature Tab, but I found a Mail Format Tab which had Signature for new messages and a listbox of choices. Also on that tab was a Compose in... combobox which was set to HTML. Hmm thinks I.

I changed that option to RTF and used my same code... no signature. I put the Compose in... option back to HTML and changed my code to

DoCmd.SendObject acSendNoObject, , acFormatHTML, strEmailAddress, , , strEmailSubject, strEmailBody, True

Still no signature.

The heck with it! Only one user will be using this feature, I'm just going to hard code a signature block along with the body text already coded in strEmailBody.

Thanks anyway and if I don't catch you in the lists before it, have a great Christmas and a Safe New Year.

Jim

[JustJim]

Just noticed something interesting, no matter if I export as acFormatHTML or acFormatRTF, Outlook uses Word as the editor and in the title bar shows Plain Text. Even if I turn off Word as the e-mail editor for new messages!

Jim

[ADezii]

In Outlook 2003 SP2 there ain't a Signature Tab, but I found a Mail Format Tab which had Signature for new messages and a listbox of choices. Also on that tab was a Compose in... combobox which was set to HTML. Hmm thinks I.

I changed that option to RTF and used my same code... no signature. I put the Compose in... option back to HTML and changed my code to

DoCmd.SendObject acSendNoObject, , acFormatHTML, strEmailAddress, , , strEmailSubject, strEmailBody, True

Still no signature.

The heck with it! Only one user will be using this feature, I'm just going to hard code a signature block along with the body text already coded in strEmailBody.

Thanks anyway and if I don't catch you in the lists before it, have a great Christmas and a Safe New Year.

Jim

The same goes for you Jim, have a happy Holiday!

[Denburt]

Just noticed something interesting, no matter if I export as acFormatHTML or acFormatRTF, Outlook uses Word as the editor and in the title bar shows Plain Text. Even if I turn off Word as the e-mail editor for new messages!

Jim

That is interesting, I might just have to look at that.

I did do a little digging, and from what most people are saying is that the signature can be placed in the body automatically as you create a new email, but as soon as you make changes to the body (in VBA) the sig is replaced. If this is in fact what is happening then I would think you could extract the signature before changing the body and add it to the body you are changing it to. Although the following link is for use in Outlook it may help accomplish such a task.

http://www.outlookcode.com/codedetail.aspx?id=615

[JustJim]

That is interesting, I might just have to look at that.

I did do a little digging, and from what most people are saying is that the signature can be placed in the body automatically as you create a new email, but as soon as you make changes to the body (in VBA) the sig is replaced. If this is in fact what is happening then I would think you could extract the signature before changing the body and add it to the body you are changing it to. Although the following link is for use in Outlook it may help accomplish such a task.

http://www.outlookcode.com/codedetail.aspx?id=615

Thanks for that. It's a little complex and, as you say designed for use in Outlook. Going through it so I understand it and then transcribing it to control Outlook from Access sounds like a wonderful holiday entertainment (I am one weird puppy!)

Happy <insert observed holiday here>

Jim

Smile.Width = Gift.Value * Giver.Love^2

[Denburt]

Just a quick follow up here. So far I have been unable to retrieve the signature using CDO (which is what I normally use to send emails) and I am currently unable to use sendObject because I am currently running two version of office and they are conflicting. I can't send anything via Outlook from any of my other office apps. LOL However I did manage to retrieve the signature using Outlook and new mailitem (see link below). I currently have my settings in Outlook to send the signature with all new email items. The interesting thing is that the signature is not placed in the email until it is displayed on screen. Go figure. Once you use the .display option you can use the .body to extract the signature then do as you please with it.

Hope this helps, good luck.

http://support.microsoft.com/kb/161088

[JustJim]

<snip> you can use the .body to extract the signature then do as you please with it.

Must be the holiday season. If you "do as you please" with the .body then you are going to have to pay for it!

Happy New Year

Jim
Oops, I messed up the quote codes, Happy New Year anyway

[Denburt]

Must be the holiday season. If you "do as you please" with the .body then you are going to have to pay for it!

Happy New Year

Jim
Oops, I messed up the quote codes, Happy New Year anyway

ROFLMAO
Fixed the quotes for you...

First I would like to say that I have never abused the body of an email before but then that brings to question what is abuse of an email body...

Second I have never paid for the use of a .body, unless you include the many credit cards my wife has, oh and the ring on her finger/fingers, the earrings she wears, and the bank account that doesn't exist anymore, etc. seriously I am just joking (in case she reads this).
Yeah sometimes I forget to explain myself in enough detail for some of you with your minds in the gutter and all but don't worry I understand it must be the holidays, maybe you should ease up on the Eggnog and such.

Well you have a Happy New Year as well.