send to mail recipient (as attachment) command button on toolbar

[phillip9]

Hello everyone,

I have an Access Application created in Access 2003. I have added the Send
to mail recipient (as attachment) command button to the print preview
toolbar. On my computer using Access 2003 it works fine. At my clients who
uses Access 2000(9.0.2720), the button is greyed out.

I have also tried this application on another computer using Access 2002 and
the button works in Access 2002 and 2003. Is there a reason it would not
work in Access 2000? Can I add this missing component or feature to Access
2000?

Is there another way to easily put a button or something on a report that
makes it easy for the users to send a displayed report to their email program
as an attachment?


thank you ,

phillip

 

[Damian S]

Hi Phillip,

You can use the following to email a report:

docmd.SendObject acSendReport, "NAME", acFormatSNP, "TOEMAIL", "CCEMAIL",
"BCCEMAIL", "SUBJECT", "MESSAGETEXT", false

The false at the end means send without waiting for further editing. You
would place this code behind a command button on your form - where you are
opening your report from - ie: one button would open the report, another
button would email it.

Hope this helps.

Damian.

 

[phillip9]

Hello Damian,

Thank you for the information, but that will not work on a report page,
because you can not put functional buttons on a report. I wanted to use the
built-in toolbar command "send to mail recipient (as attachment)", but when I
put this command button on the toolbar it is not active, (it is greyed out).

My thinking is that a component is not installed in the clients version of
Access 2000, so maybe I just need to reinstall from the install CD-ROM.

If anyone has other ideas , please let me know.


thanks,

phill

 

[Damian S]

I am aware of this fact, which is why I told you that you would need to have
the button on the form that opens the report. Good luck in your search.

Damian.

 

[Chris Reveille]

The MS Outlook reference in your vb references is different in Access 2000
and Access 2003
Go in and check your outllook refeence when you in a VB module
Access 2000 uses MS Outllook library 9.0
Access 2003 uses MS Outlook library 11.0

I have to make this change when I use different Access versions.