Email Sent Using Docmd.Sendobject

Topic

New Reply

Welcome back!
I am using a DoCmd.SendObject command to send an email; the code fills in a Bcc list and the subject line if the user has supplied one or, if not, leaves the subject line blank.

The user has noticed that the resultant email cannot be minimised. The Maximise box works, as does the Close box, but although the Minimise button is present, it does nothing.

The user is asking two things.
1. Can the minimise box be made to work?
2. Her email signature is not inserted (as it is when she sends a normal email) so can her signature be included?
(I’ve suggested using the signature icon on the Standard toolbar menu as a work round, but she wants it included automatically as it is when sending a normal email from Outlook)

Thanks
Silverback

Reply | Quote

Replies

> 1. Can the minimise box be made to work?

No, the user has to either send the message or discard it before being able to return to Access.

> 2. Her email signature is not inserted (as it is when she sends a normal email) so can her signature be included?

No, the process that creates the message operates at a very basic level: the message will always be plain text, and default formatting, signature etc. are not added.

Reply | Quote

To get the functionality you want you will need to use VBA to create the email,
rather than the simple docmd.sendobject method.

You can find an example here

If you use variations of this example you would need to set a reference to Outlook,
under Tools References in the VBE.

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

Reply | Quote

Thank you, Andrew and Hans
User has accepted work rounds of
a: resizing/moving the window on the rare occasions when she wants to see something under the email
b: inserting her signature using the signature button on the toolbar.

Phew – close call there; Automation looked really heavy!
Thanks for your help
Silverback

Reply | Quote

I came across this post while looking into the same question.

I use a mixture of Automation and SendObject in various places, depending on whether I want an attachment. I try to support users who don’t use Outlook as the default mail program.
On my computer I use Thunderbird as my default mail program.

For me messages created with Docmd.SendObject do get my default signature, and messages created with Automation don’t.
This is the exact opposite of what is said above.

When I look into the question of Outlook and Automation I find a range of answers:

[*]Outlook signatures happen automatically – not for me they don’t.[*]You need to use Outlook Object Inspectors – this seems to be a way of programmatically using the Insert Signature button in Outlook. I have never tried to use Object Inspectors before, and they did not work for me.[*]Find the file that holds the signature, open it, then write the contents of that file into the email. The location of this file varies depending on the version of Office and the version of Windows, so I was not attracted to the complications of this.

I think I will resort to Silverback’s workaround – tell users to click the Signature button – but I am wondering if anyone out there does get signatures inserted automatically into Outlook.

Reply | Quote