email button is grey-ed out

[Jamescdawson]

I have a function in my database that generates a report for a given customer name and date range. It's usually a single page report. Once created and displayed on screen, the user would normally click on the Email button in the ribbon. This would bring up a menu of file attachment options.... The user would normally choose .pdf The emailer window would then be displayed with the report appearing in the attachment field. An email address and covering note would be entered and the emai sent.



All Good

For some reason, this has stopped working and when I click the email button, I am told I need to configure my computer for email. (!?!) Another user tells me that the email button has been grey-ed out on her ribbon. She recently had a new computer and the latest version of Outlook installed.

I am sill using the same version I always have, so I'm baffled as to why this would happen.

Any pointers how I "connect" the email button in the ribbon to the database ??

Jimbo

[rpeare]

why not just create a 'email this report' button on your form. If the whole goal of even opening the report is to email it you can email it with a button click using something like

docmd.sendobject blah blah

or other email method (sendobject won't allow multiple attachments for example)

[GinaWhipp]

This can happen when the Access version and the Outlook version are not the same. As indicated above creating a button using DoCmd.SendObject will bypass that using whatever version of Outlook is installed. Or, you could use a Function that uses Late Binding which will also use the version of Outlook installed.

[isladogs]

Or you could use collaborative data objects (CDO) to send email directly from Access bypassing Outlook completely